Top Stores by Revenue | Dataford Interview Questions

Write a query to find the top three performing store locations in a specific region based on total revenue.

Use the stores and sales tables, with Midwest as the region. Stores with a NULL region are ignored.

Output

One row per qualifying store, with store_id, store_name, total_revenue, and revenue_rank.
Return only the three highest-revenue stores, breaking ties by the smaller store_id.
Order rows by total_revenue descending, then store_id ascending.

stores

Column	Type	Description
store_idPK	INTEGER	Unique store identifier
store_name	VARCHAR(100)	Store location name
region	VARCHAR(50)	Geographic region containing the store

sales

Column	Type	Description
sale_idPK	INTEGER	Unique sale identifier
store_id	INTEGER	Store associated with the sale
sale_amount	NUMERIC(12,2)	Revenue recorded for the sale

Your question is Top Stores by Revenue. Start with the requirements and the two 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.