Question

Question 2
A data analyst organizes a database to show only the 100 most recent real estate sales in Stamford, Connecticut. What steps do they take?

Add a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.



Filter out sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.



Add a filter to return only sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.



Filter out sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.


1 point

Answer 1

Add a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.

Explanation: you need to include only Stamford records (filter in), sort by date descending (most recent first), then take the top 100.