Top 5 Best-Selling Models Query | Dataford Interview Questions

Write a query to find the top 5 best-selling car models from a given sales table.

Count only rows where sale_status is completed, and exclude records without a car model. Break ties alphabetically by model_name.

Output

One row per selected car model
Columns: model_name and sales_count
Return at most five rows, ordered by sales_count descending, then model_name ascending

sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
model_name	VARCHAR(100)	Car model sold
sale_status	VARCHAR(30)	Current status of the sale
sold_at	DATE	Date associated with the sale

Your question is Top 5 Best-Selling Models Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write a query to find the top 5 best-selling car models from a given sales table.

Count only rows where sale_status is completed, and exclude records without a car model. Break ties alphabetically by model_name.

One row per selected car model
Columns: model_name and sales_count
Return at most five rows, ordered by sales_count descending, then model_name ascending

sales

Column	Type	Description
sale_idPK	INT	Unique identifier for the sale
model_name	VARCHAR(100)	Car model sold
sale_status	VARCHAR(30)	Current status of the sale
sold_at	DATE	Date associated with the sale

Your question is Top 5 Best-Selling Models Query. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.