Coursera - SQL for Data Science - Week-1.sql

-- 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.

Select * from employees


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

Select FirstName,
LastName,
Birthdate,
Address,
City,
State from employees


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

Select * from Tracks
Limit 20