Top 5 Customers by Order Value | Dataford Interview Questions

Write a SQL query to retrieve the top 5 customers by order value.

Use the customers and orders tables. Treat order value as the sum of all order values for each customer.

Output

Return one row per customer with customer_id, customer_name, and total_order_value.
Include the five highest totals, ordered descending, with customer_id ascending as the tie-breaker.

customers

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

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
order_value	NUMERIC(12,2)	Monetary value of the order
order_date	DATE	Date the order was placed

Your question is Top 5 Customers by Order Value. 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.