SQL: Customers With At Least One Order Over $500 (EXISTS)

MediumDatabases

Description

> This problem is paper-only - see explanation for the canonical SQL solution. Given `Customers(id, name)` and `Orders(id, customer_id, total)`, return customer names who have at least one order over $500. Sort alphabetically. The canonical pattern is `WHERE EXISTS (...)` - know why it usually beats `IN (...)` and `JOIN ... DISTINCT`. **For the auto-grader:** implement `customersWithBigOrder(customers, orders)`.

Example 1

Input: customers = [{id:1,name:"Alice"},{id:2,name:"Bob"}], orders = [{id:1,customer_id:1,total:600},{id:2,customer_id:2,total:50}]

Output: ["Alice"]

Constraints

- 0 <= customers.length, orders.length <= 10^4

Loading editor...