A customer's spend is the sum of total_amount over all their orders. Show customer_id,
full_name and spent for the customers whose spend is above the average spend of the
customers who have ordered.
End your query with ORDER BY spent DESC, customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| total_amount |
A customer's spend is the sum of total_amount over all their orders. Show customer_id,
full_name and spent for the customers whose spend is above the average spend of the
customers who have ordered.
End your query with ORDER BY spent DESC, customer_id.
| customers |
|---|
| customer_id (PK) |
| full_name |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| total_amount |
| customer_id | full_name | spent |
|---|---|---|
| 14 | Arun Joshi | 207580.70 |
| 7 | Neha Gupta | 201445.50 |
| 6 | Vikash Yadav | 188762.25 |
| 2 | Rahul Sharma | 182688.70 |
| 18 | Nikhil Bose | 178039.40 |
| 25 | Sara D'Souza | 177466.85 |
| 5 | Pooja Singh | 164245.00 |
| 11 | Anita Desai | 154274.15 |
| 16 | Karan Malhotra | 141308.10 |
| 17 | Pallavi Kulkarni | 141103.90 |
| 1 | Aisha Verma | 140209.20 |
Run query to see output