Total Spend Per Customer | Dataford Interview Questions

Use SQL to find the total amount spent by each customer.

Return every customer represented in the data. Treat missing transaction amounts as contributing nothing to the customer's total.

Output

One row per customer.
Columns named customer_name and total_spent.
Include all customers and sort by total_spent descending, then customer_name ascending to break ties.

orders

Column	Type	Description
order_idPK	INTEGER	Unique identifier for the order
customer_name	VARCHAR(100)	Name of the customer who placed the order
amount	DECIMAL(10,2)	Amount spent on the order

Your question is Total Spend Per Customer. 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.

Use SQL to find the total amount spent by each customer.

Return every customer represented in the data. Treat missing transaction amounts as contributing nothing to the customer's total.

One row per customer.
Columns named customer_name and total_spent.
Include all customers and sort by total_spent descending, then customer_name ascending to break ties.

orders

Column	Type	Description
order_idPK	INTEGER	Unique identifier for the order
customer_name	VARCHAR(100)	Name of the customer who placed the order
amount	DECIMAL(10,2)	Amount spent on the order

Your question is Total Spend Per Customer. 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.