Find bulk orders in a price band (kite shop)
Keep orders of at least 4 units priced under 20, ignoring rows with no quantity.
- Level
- beginner
- Time
- ~7 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Combine numeric conditions with and, and understand how null behaves in comparisons.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- Keep rows where
Qtyis at least 4 andUnitPriceis less than 20. - Rows with no Qty must not appear.
Your result must
- Every kept row has Qty ≥ 4 and UnitPrice < 20
- No rows with a null Qty
- All columns kept
Input
- Orders (table)
- OrderID: text
- Customer: text
- Region: text
- Product: text
- Qty: number (nullable)
- UnitPrice: number
- OrderDate: text
- Status: text
Expected output columns
OrderID (text), Customer (text), Region (text), Product (text), Qty (number), UnitPrice (number), OrderDate (text), Status (text)
| OrderID | Customer | Region | Product | Qty | UnitPrice | OrderDate | Status |
|---|---|---|---|---|---|---|---|
| 0002 | Wen Zielinski | North | Box Kite | 5 | 9.86 | 2026-05-06 | Complete |
| 0010 | Yara Jovanovic | South | Box Kite | 4 | 6.16 | 2026-02-21 | Pending |