Top Three Customers Query | Dataford Interview Questions

Write a SQL query to find the top three customers based on purchase frequency.

Assume purchase frequency means the number of completed purchases. Exclude cancelled or otherwise non-completed purchases, and use the customer ID as the tie-breaker.

Output

One row per customer with customer_id, customer_name, and purchase_frequency.
Return the top three customers, ordered by purchase frequency descending and customer ID ascending for ties.

Schema

customers

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

purchases

Column	Type	Description
purchase_idPK	INT	Unique purchase identifier
customer_id	INT	Customer associated with the purchase
purchase_status	VARCHAR(20)	Purchase processing status

Your question is Top Three Customers Query. 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.

Problem