Module 2 Coding Questions >> Week 1 >> SQL for Data Science
1. Question 1 All of the questions in this quiz refer to the open source Chinook Database. Please familiarize yourself with the ER diagram to familiarize yourself with the table and column names to write accurate queries and get the appropriate answers. Run Query: Find all the tracks that have a length of 5,000,000 milliseconds or more. 123 select Count(TrackId) from Track where Milliseconds >= 5000000 Reset How many tracks are returned? 1 point 2 2. Question 2 All of the questions in this quiz refer to the open source Chinook Database. Please familiarize yourself with the ER diagram to familiarize yourself with the table and column names to write accurate queries and get the appropriate answers. Run Query: Find all the invoices whose total is between $5 and $15 dollars. 123 select count(DISTINCT i.InvoiceId) from Invoice as i where i.Total between 5 and 15 Reset While the query in this example is limited to 10 records, running the query correctly will indicate how many total records there are – enter that number below. 1 point 168 3. Question 3 All of the questions in this quiz refer to the open source Chinook Database. Please familiarize yourself with the ER diagram to familiarize yourself with the table and column names to write accurate queries and get the appropriate answers. Run Query: Find all the customers from the following States: RJ, DF, AB, BC, CA, WA, NY. 123 select FirstName, LastName, Company, State from Customer where State in (‘RJ’, ‘DF’, ‘AB’, ‘BC’, ‘CA’, ‘WA’, ‘NY’) Reset What company does Jack Smith work for? 1 point Microsoft Corp Google Inc. Rogers Canada Apple Inc. 4. Question 4 All of the questions in this quiz refer to the open source Chinook Database. Please familiarize yourself with the ER diagram to familiarize yourself with the table and column names to write accurate queries and get the appropriate answers. Run Query: Find all the invoices for customer 56 and 58 where the total was between $1.00 and $5.00. 123 select InvoiceId, InvoiceDate, CustomerId, Total from Invoice where CustomerId in (56, 58) AND (Total >= 1.00 and Total
*Please Wait 15 Seconds To Get The Pdf Loaded
