Top Cities by Order Amount | Dataford Interview Questions

Given a table Orders(City, OrderDate, Amount), return the top 3 cities by total order amount along with their rank (output City, TotalAmount, Rank; only ranks 1-3).

Asked in the Round 1 live SQL stage. Wording restructured by OP with ChatGPT.

Output

One row per city, with columns City, TotalAmount, and Rank.
Include only cities whose rank is 1, 2, or 3. Cities tied on total amount must share the same rank.
Sort by rank ascending, then city name ascending.

Schema

orders

Column	Type	Description
city	VARCHAR(100)	City associated with the order
orderdate	DATE	Date on which the order was placed
amount	DECIMAL(12,2)	Monetary value of the order

Your question is Top Cities by Order Amount. 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.

Problem