Your question is Average Order Value by Region. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
orders to users using user_id.region.avg_order_value.avg_order_value descending, then region ascending.| 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 |
| 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 |