SQL for Data-science Coursera Assignment Answers

Week 1 Coding

1. Retrieve all the records from the Employees table.

code:

select * from Employees;

What is Robert King's mailing address? Note: You will have to scroll to the right in order to see it.

Answer : 590 Columbia Boulevard West, Lethbridge, AB, CANADA T1K 5N8

2. Retrieve the FirstName, LastName, Birthdate, Address, City, and State from the Employees table.)

code:

select FirstName, LastName, Birthdate, Address, City, State from Employees

Which of the employees listed below has a birthdate of 3-3-1965?

Answer : Steve

3. Retrieve all the columns from the Tracks table, but only return 20 rows.

code:

select * from Tracks limit 20;

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.

Answer : 375418