Average Order Value by Segment | Dataford Interview Questions

Write a SQL query to find the average order value by customer segment.

Use the orders table and include all defined customer segments. Order values that are NULL should not affect the calculated average.

Output

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_segment	VARCHAR(50)	Customer segment assigned to the order
order_value	DECIMAL(10,2)	Monetary value of the order

Your question is Average Order Value by Segment. 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.

Write a SQL query to find the average order value by customer segment.

Use the orders table and include all defined customer segments. Order values that are NULL should not affect the calculated average.

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_segment	VARCHAR(50)	Customer segment assigned to the order
order_value	DECIMAL(10,2)	Monetary value of the order

Your question is Average Order Value by Segment. 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.