Keep only completed orders (kite shop)
Filter out cancelled and pending orders so only completed sales remain.
- Level
- beginner
- Time
- ~5 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Filter rows on an exact text value with a repeatable condition.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- Keep rows where
StatusequalsComplete. - Keep all columns.
Your result must
- Only Complete orders remain
- All columns kept
- Works on next week's export
Input
- Orders (table)
- OrderID: text
- Customer: text
- Region: text
- Product: text
- Qty: number
- 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 |
|---|---|---|---|---|---|---|---|
| 0001 | Zane Kowal | East | Tail Ribbon | 5 | 42.16 | 2026-05-07 | Complete |
| 0002 | Rosa Grieve | East | Reel | 6 | 6.01 | 2026-02-16 | Complete |
| 0005 | Wen Zielinski | South | Reel | 9 | 3.42 | 2026-04-01 | Complete |