Mock interview. You're interviewing for a data analyst job on an online shop's retail team. The interviewer shares orders and customers. "Let's look at the first quarter of 2026."
Leave out cancelled orders: they never turned into sales. Average order value (AOV) is revenue divided by orders.
"Give me Q1 2026 in one row: orders, customers who ordered, revenue (total_amount) and AOV."
Expected output
Return: orders, customers, revenue and aov (name the columns however you like)
aov rounded to 2 decimalsExample of the shape (made-up values):
| orders | customers | revenue | aov |
|---|---|---|---|
| 250 | 160 | 15000.00 | 60.00 |
Step 1 of 2
Write your query here. Ctrl + Enter submits.