SQL: Big Spenders (GROUP BY + HAVING)

MediumDatabases

Description

> This problem is paper-only - see explanation for the canonical SQL solution. Given `Orders(id, customer_id, total)`, return customer_ids whose **total spend exceeds 1000**. Sort by total spend descending, then customer_id ascending as a tiebreaker. **For the auto-grader:** return `[{ customer_id, total_spend }]`.

Example 1

Input: orders = [{id:1,customer_id:1,total:600},{id:2,customer_id:1,total:500},{id:3,customer_id:2,total:200},{id:4,customer_id:3,total:1500}]

Output: [{customer_id:3,total_spend:1500},{customer_id:1,total_spend:1100}]

Constraints

- 0 <= orders.length <= 10^4 - 0 <= total <= 10^6

Loading editor...