In this project, you will query the Chinook Database. The Chinook Database holds information about a music store.
For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information.
To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows.
You need to come up with 4 questions that you can answer with SQL. The questions must be complex enough to where the SQL used to answer it requires at least one JOIN and one Aggregation.
In this project we will use our local environment SQLite
Your presentation should include:
- Four slides
- One visualization per slide (You can export your query results from DB Browser to a csv and use Excel or any other spreadsheet software to create an appropriate chart)
- A 1-2 sentence explanation of each slide