Customers Without Orders
Return the name of every customer who has no order at all. Rows may come in any order.
Example 1
customers
| id | name |
|---|---|
| 1 | Ada |
| 2 | Ben |
| 3 | Cy |
orders
| id | customer_id | amount |
|---|---|---|
| 10 | 2 | 50.0 |
| 11 | 2 | 20.5 |
returns
| name |
|---|
| Ada |
| Cy |
Constraints
- Up to 6 customers and 10 orders
- Names are unique
Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.
More SQL problems
- Low and HighEasy
- Net PositionEasy
- Orders With NamesEasy
- Pay With BonusEasy
- Small, Medium, LargeEasy
- Total per SymbolEasy
- Totals by MonthEasy
- Above the AverageMedium