Average Order Value by Region | Dataford Interview Questions

Whatnot's operations team wants a quick view of buyer monetization by geography. Write a SQL query to calculate the average order value per user by region.

Requirements

Join orders to users using user_id.
Group results by region.
Return each region and its average order value as avg_order_value.
Exclude orders that are not linked to a valid user region.
Order the final result by avg_order_value descending, then region ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
username	VARCHAR(50)	Whatnot username
region	VARCHAR(50)	User region
signup_date	DATE	Date the user joined Whatnot

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
user_id	INT	User who placed the order
order_total	DECIMAL(10,2)	Total order amount
order_date	DATE	Date of purchase

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