![]() Find the structure of the ‘customers’ table by double clicking on the table name. Download the Chinook database from the SQLite tutorial (0.5 pts)ģ. ![]() Download SQLiteStudio from () (0.5 pts)Ģ. 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). If you are already familiar with SQL, you will notice the differences between SQL standard and the SQL dialect used in SQLite.For the questions in this assignment, you will use SQLiteStudio to analyze a database. You will first start querying data from the sample database. This section presents basic SQL statements that you can use with SQLite. Finally, guide you on how to use the sqlite3 commands.Third, introduce you to an SQLite sample database and walk you through the steps of using the sample database for practicing.Second, show you step-by-step how to download and install the SQLite tools on your computer.First, help you answer the first and important question: what is SQLite? You will have a brief overview of SQLite.Follow these 4-easy steps to get started with SQLite fast. You should go through this section if this is the first time you have worked with SQLite. SQLite is an open-source, zero-configuration, self-contained, stand-alone, transaction relational database engine designed to be embedded into an application. This SQLite tutorial is designed for developers who want to use SQLite as the back-end database or to use SQLite to manage structured data in applications including desktop, web, and mobile apps. In this tutorial, you will learn SQLite step by step through extensive hands-on practices. This SQLite tutorial teaches you everything you need to know to start using SQLite effectively.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |