SQL Query Difficulty Pair | Dataford Interview Questions

They ask you two SQL questions, one easy and one hard. How do you handle both?

Write PostgreSQL queries using the provided customers and orders tables. The easy result summarizes completed orders for every customer. The hard result returns customers with at least two completed orders and ranks them within their region by completed spend.

Output

Return one combined result set with question_level, customer_name, total_completed_spend, completed_order_count, and region_rank.
Include all customers in the easy rows. Include only qualifying customers in the hard rows.
Sort by question_level, then customer_name.

Schema

customers

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

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
status	VARCHAR(20)	Order lifecycle status
amount	NUMERIC(10,2)	Order amount

Your question is SQL Query Difficulty Pair. 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