Total Spend Per Customer
Medium
joins
Amazon
Stripe
Shopify
Join customers and orders, then aggregate to find the total amount spent by each customer. Only include customers who have placed at least one order.
Expected Output
| customer_name | total_spent |
|---|---|
| Alice | 180.0 |
| Bob | 95.0 |
| Carol | 60.0 |
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...