SQL for Customer Data Extraction | Dataford Interview Questions

Write a SQL query to extract specific customer data from a database.

Use the provided customers and orders tables. Return customers with completed orders from January 1 through March 31, 2025, whose total order value exceeds 50.

Output

One row per qualifying customer.
Columns: customer_id, full_name, email, completed_order_count, total_spent, and last_order_date.
Sort by total_spent descending, then customer_id ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
full_name	VARCHAR(100)	Customer's full name
email	VARCHAR(255)	Customer email address

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
status	VARCHAR(20)	Order status
order_total	DECIMAL(10,2)	Total value of the order
order_date	DATE	Date the order was placed

Your question is SQL for Customer Data Extraction. 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