Type: Individual ProjectUnit: SearchingAt this point, you want to put together the work that has been completed to deliver a working program for alpha testing. If completed correctly, I will add 2 points to your cumulative homework score total. You may need to extract the results of the query (Tools -> Export) to another programī. Track on a playlist correlate to higher sales of that track?Ī.
BONUS: Look at the ‘playlist’ table and all the tracks that make up the playlists. What is the most popular genre of music sold at the music store (measured by total number ofġ0. What music tracks have sold the most copies at the music store? (1 Pt)ĩ. Which customer (first and last name, please) has spent the most at the music store? (1 Pt)Ĩ. How many invoices does each customer have? (1 Pt)ħ. Now let’s examine the available invoices. How many states do the customers come from? Is there any missing data? (1 Pt)Ħ. How many unique customers does this music store have? (1 Pt)ĥ. Find the structure of the ‘customers’ table by double clicking on the table name.
#Sqlitestudio structure download
Download the Chinook database from the SQLite tutorial (0.5 pts)ģ. Download SQLiteStudio from () (0.5 pts)Ģ.
#Sqlitestudio structure code
Please take screenshots of your SQL code as well as of the results (can be in the same screenshot)ġ. MET AD599 Introduction to Python and SQL for Business AnalyticsĪssignment #4 – For the questions in this assignment, you will use SQLiteStudio to analyze a database. Does having a track on a playlist correlate to higher sales of that track?Ī.You may need to extract the results of the query (Tools -> Export) to another program like Excel or Python to complete this.ī.If completed correctly, I will add 2 points to your cumulative homework score total. How many invoices does each customer have?ħ.Which customer (first and last name, please) has spent the most at the music store?Ĩ.What music tracks have sold the most copies at the music store?ĩ.What is the most popular genre of music sold at the music store (measured by total number of tracks sold)?ġ0.BONUS: Look at the ‘playlist’ table and all the tracks that make up the playlists. Which column is the primary key of the table?Ĥ.How many unique customers does this music store have?ĥ.How many states do the customers come from? Is there any missing data?Ħ.Now let’s examine the available invoices. Please check the attached word document as well.ġ.Download SQLiteStudio from ()Ģ.Download the Chinook database from the SQLite tutorialģ.Find the structure of the ‘customers’ table by double clicking on the table name. You can ignore question 1 and please answer bonus question 10 as well. Answer each question using screenshots of SQL code(copy and paste the screenshots) and write the answer below each question in the Word document. Please take screenshots of your SQL code as well as of the results (can be in the same screenshot). For the questions in this assignment, you will use SQLiteStudio to analyze a database.
0 kommentar(er)
