Prepare Data For Exploration Weekly Challenge 3 (Part 2)
6.
A data analyst reviews a database of Wisconsin car sales to find the last car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars sold at the top of their list? Select all that apply.
Sort by sale date in ascending order
Filter out sales not in 2019 (Correct)
Sort by sale date in descending order (Correct)
Filter out sales outside of Milwaukee (Correct)
7.
When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.
True (Correct)
False
8.
You are working with a database table that contains customer data. The first_name column lists the first name of each customer. You are only interested in customers with the first name Mark. You write the SQL query below. Add a WHERE clause that will return only customers named Mark.
9.
How many customers are named Mark?
