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...