Top 3 Customers by Month | Dataford Interview Questions

What SQL query would you use to find the top 3 customers by total spend for each month?

Use the provided customers and orders tables. Return exactly three customers per month, breaking spend ties by the lower customer_id.

Output

One row per customer-month with month_start, customer_id, customer_name, and total_spend
Include only the top three customers in each month
Order by month_start ascending, total_spend descending, then customer_id ascending

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
order_date	DATE	Date the order was placed
amount	NUMERIC(12,2)	Order spend amount

Your question is Top 3 Customers by Month. 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.