Module 1 Coding Questions >> Week 1 >> SQL for Data Science

Module 1 Coding Questions >> Week 1 >> SQL for Data Science

1. Question 1 For all of the questions in this quiz, we are using the Chinook database. All of the interactive code blocks have been setup to retrieve data only from this database. Retrieve all the records from the Employees table. 1 Reset What is Robert King’s mailing address? Note: You will have to scroll to the right in order to see it. 1 point 683 10 Street SW, Calgary, AB, CANADA T2P 5G3 590 Columbia Boulevard West, Lethbridge, AB, CANADA T1K 5N8 11120 Jasper Ave. NW, Edmonton, AB, CANADA T5K 2N1 1111 6 Ave SW, Calgary, AB, CANADA T2P 5M5 2. Question 2 Retrieve the FirstName, LastName, Birthdate, Address, City, and State from the Employees table. 1 Reset Which of the employees listed below has a birthdate of 3-3-1965? 1 point Nancy Jane Robert Steve Michael 3. Question 3 Retrieve all the columns from the Tracks table, but only return 20 rows. 1 Reset What is the runtime in milliseconds for the 5th track, entitled “Princess of the Dawn”? Note: You will need to scroll to the right to see it, and you may want to copy and paste the number to ensure it is entered correctly. 1 point 375418

*Please Wait 15 Seconds To Get The Pdf Loaded

Leave a Comment