8/25/2023 0 Comments Chinook database sqlite studio![]() ✔️ Looking at the InvoiceLine table, provide a query that COUNTs the number of line items for Invoice ID 37.✔️ How many Invoices were there in 20? What are the respective total sales for each of those years?.✔️ Provide a query that shows the Invoice Total, Customer name, Country and Sale Agent name for all invoices and customers.The resultant table should include the Sales Agent's full name. ✔️ Provide a query that shows the invoices associated with each sales agent.✔️ Provide a query showing a unique list of billing countries from the Invoice table.✔️ Provide a query showing only the Employees who are Sales Agents.The resultant table should show the customer's full name, Invoice ID, Date of the invoice and billing country. ✔️ Provide a query showing the Invoices of customers who are from Brazil.✔️ Provide a query only showing the Customers from Brazil.✔️ Provide a query showing Customers (just their full names, customer ID and country) who are not in the US.Keep your successful queries in a chinook.sql file. Use the Chinook Database and the DB Browser for SQLite we downloaded in the ERD exercise.įor each of the following exercises, provide the appropriate query. Let's cement your SQL query bonafides with a tougher test of your new skills. Do your best to glean the relationships from the tables and make a complete ERD before peeking to see if you've hit the mark. ⚠️ Be a good, honest, upstanding citizen and don't click the link on the Chinook home page to view the data model or search Google images for "Chinook database". ✔️ Open the Chinook database in DB Browser. ![]() As the site tells us, "The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers." Requirements Part 1: ERD Introductionīefore we move on to shiny, new things we are going to ramp up the difficulty a bit, and introduce you to the Chinook Database, a sample db that countless back end devs have used for practicing their SQL skills. SQL query exercise copied from this repo.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |