Practice · SQL for Data Interviews
Medium problems
Each problem runs against the same e-commerce dataset, so the schema you learn in one problem carries over to the next. Write a query, run it, and grade it in your browser.
- Category revenue by country
- Customer category coverage
- Customer order counts including zero
- Customer order span
- Customer revenue without fan-out
- Customers above average order count
- Customers above average spend
- Customers per order status
- Customers who bought product 17
- Customers with exactly one order
- First order per customer
- January buyers who skipped March
- Monthly activity reconciliation
- Monthly revenue change
- Monthly signups and orders
- Orders above average value
- Orders above the customer's average
- Orders by channel and status
- Orders with multiple products
- Pending order details
- Product pairs bought together
- Product price bands
- Refund share by category
- Revenue by month and channel
- Revenue per customer by country
- Revenue share by order status
- Signup cohort activity
- Signups by day of week
- Top products by units sold