Assignment #4 – For the questions in this assignment, you will use SQLiteStudio to analyze a database. Please take screenshots of your SQL code as well as of the results (can be in the same screenshot)

1.Download SQLiteStudio from (sqlitestudio.pl) (0 pts)

2.Download the Chinook database from the SQLite tutorial (0 pts)

a.https://www.sqlitetutorial.net/sqlite-sample-database/

3.Find the structure of the ‘customers’ table by double clicking on the table name. Which column is the primary key of the table? (1 Pt)

4.How many unique customers does this music store have? (1 Pt)

5.How many states do the customers come from? Is there any missing data? (1 Pt)

6.Now let’s examine the available invoices. How many invoices does each customer have? (1 Pt)

7.Which customer (first and last name, please) has spent the most at the music store? (1 Pt)

8.What music tracks have sold the most copies at the music store? (1 Pt)

9.What is the most popular genre of music sold at the music store (measured by total number of tracks sold)? (1 Pt)

10.BONUS: Look at the ‘playlist’ table and all the tracks that make up the playlists. Does having a track on a playlist correlate to higher sales of that track?

a.You may need to extract the results of the query (Tools -> Export) to another program like Excel or Python to complete this.