Write SQL for a Specific Problem | Dataford Interview Questions

Create a SQL to solve one specific problem

Use the customers and orders tables to calculate completed-order metrics for calendar year 2025. Include every customer, including customers without qualifying orders.

Output

One row per customer with customer_name, completed_order_count, completed_amount, and customer_status.
Classify totals of at least 1000 as Priority; classify all other customers as Other.
Order by completed_amount descending, then customer_name ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer name
customer_status	VARCHAR(20)	Current customer account status

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
order_status	VARCHAR(20)	Current order state
amount	DECIMAL(10,2)	Order amount

Your question is Write SQL for a Specific Problem. 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