SQL Joins and Aggregations | Dataford Interview Questions

Tell me about a time you wrote an SQL query to find customers who placed more than one order and sort them by total spend.

Use the provided customer and order data. Return only customers with more than one order, including orders with a zero or NULL amount in the order count.

Output

One row per qualifying customer with customer_id, customer_name, order_count, and total_spend.
Sort by total_spend descending, then customer_id ascending to break ties.

Schema

customers

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

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer who placed the order
order_total	DECIMAL(10,2)	Order amount

Your question is SQL Joins and Aggregations. 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