Write a Basic MySQL Query | Dataford Interview Questions

Write a SQL query using MySQL basics.

Use the orders table to calculate spending totals for completed orders. Return up to five customers, sorted from the highest total to the lowest, with customer names breaking ties alphabetically.

Output

One row per customer with completed orders
Columns: customer_name, total_spent
Include only the five highest totals and exclude non-completed orders
Sort by total_spent descending, then customer_name ascending

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_name	VARCHAR(100)	Customer name
amount	DECIMAL(10,2)	Order amount
order_status	VARCHAR(20)	Current order status
order_date	DATE	Date the order was placed

Your question is Write a Basic MySQL Query. 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