In junior year, one of the main things we learned in related was accessing databases with SQL.
A good example of this was the assignment using a database for a pet supplies company. It allowed us to practice getting specific data with queries, requiring us to make sometimes complex query statements that reference data across multiple tables.
The first prompt was to show the invoice number and date along with the name of who the invoice was created for. I had to use a join to reference the data in the customers and invoices tables, linking them with customer IDs.
An IN operator can also have a similar effect to joining tables. This one also has more specific results due to a WHERE statement specifying a date.
I couldn’t get all of them right, I unfortunately didn’t realize I didn’t have the right amount of results but I was shown a query that does work.
