Orders Exceeding Customer Lifetime Average
Hard
subqueries
Amazon
Stripe
Shopify
Find all individual orders whose amount exceeds that customer's own average order amount. Return order_id, customer_id, and amount, ordered by customer_id, then order_id.
Expected Output: Orders above the customer's own average.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...