SQL and BI Basics | Dataford Interview Questions

What SQL basics and BI basics have you worked with?

For the SQL portion, write a query against orders that summarizes completed orders by customer. Exclude rows without a customer name and return the five customers with the highest total spending.

Output

One row per customer with customer_name, order_count, total_spent, and average_order_value.
Ignore rows with a NULL customer_name; order by total spent descending, then customer name ascending, and return five rows.

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_name	VARCHAR(50)	Customer associated with the order
amount	NUMERIC(12,2)	Order amount
status	VARCHAR(40)	Current order status

Your question is SQL and BI Basics. 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.

Problem