SQL Top 10 Selling Cars | Dataford Interview Questions

CarGurus wants to identify the vehicle models with the highest number of completed sales through its marketplace. Write a PostgreSQL query to return the top 10 models sold during 2025.

Requirements

Join vehicle models, CarGurus listings, and sales records.
Include only completed sales made from January 1 through December 31, 2025.
Return the make, model, number of completed sales, and average sale price for each model.
Sort by completed sales descending, then average sale price descending, and return at most 10 models.

Schema

vehicle_models

Column	Type	Description
model_idPK	INT	Unique vehicle model identifier
make	VARCHAR(50)	Vehicle manufacturer
model	VARCHAR(80)	Vehicle model name
trim	VARCHAR(80)	Vehicle trim designation

listings

Column	Type	Description
listing_idPK	INT	Unique vehicle listing identifier
model_id	INT	Referenced vehicle model
marketplace	VARCHAR(40)	Marketplace associated with the listing
listing_status	VARCHAR(20)	Current listing status

sales

Column	Type	Description
sale_idPK	INT	Unique sale identifier
listing_id	INT	Referenced vehicle listing
sold_at	DATE	Date on which the vehicle was sold
sale_status	VARCHAR(20)	Outcome of the sale transaction
sale_price	NUMERIC(10,2)	Final transaction price

Your question is SQL Top 10 Selling Cars. Start with the requirements and the three tables 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.

Problem