Keep orders for a list of products (kite shop)
Keep only orders whose Product is in the promotion list held in a separate PromoProducts table.
- Level
- intermediate
- Time
- ~7 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Filter against a list of values from another query with List.Contains.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
PromoProductshas one column,Product.- Keep orders whose
Productappears in that list. - Keep all order columns.
Your result must
- Only promotion products remain
- Changing the promotion table changes the result
- All columns kept
Input
- Orders (table)
- OrderID: text
- Customer: text
- Region: text
- Product: text
- Qty: number
- UnitPrice: number
- OrderDate: text
- Status: text
- PromoProducts (table)
- Product: 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 | Zane Lindqvist | North | Stunt Kite | 3 | 47.86 | 2026-06-14 | Cancelled |
| 0004 | Esi Haddad | South | Stunt Kite | 7 | 11.32 | 2026-03-22 | Pending |
| 0006 | Hana Zielinski | South | Stunt Kite | 1 | 57.37 | 2026-03-04 | Cancelled |