Question

1. a data analyst reviews a database of wisconsin car sales to find the last five 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 sort by sale date in descending order filter out sales outside of milwaukee filter out sales not in 2019

Explanation:

1. To target the correct dataset, first filter out sales not in Milwaukee and not in 2019, as the goal is only 2019 Milwaukee car sales.
2. To get the last five sold cars at the top of the list, sort the filtered data by sale date in descending order (newest dates first), which places the most recent (last) sales at the top. Ascending order would put the oldest sales first, which is not desired.

Answer:

B. Sort by sale date in descending order
C. Filter out sales outside of Milwaukee
D. Filter out sales not in 2019