Remove a leftover step that cuts the data short (kite shop)
A Kept First Rows step left over from testing silently drops orders. Find it and remove it.
- Level
- beginner
- Time
- ~6 min
- Task
- Fix a broken query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Read the applied steps of a query and spot a step that only works for today's data.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- The query should return every order whose
Statusisn'tCancelled, sorted byOrderDateascending and thenOrderIDascending. - Someone added a
Kept First Rowsstep while testing. Remove it so no orders are lost, and keep the other steps. - Keep all columns. Row order is graded.
Your result must
- No Cancelled orders
- Every other order is present
- Sorted by OrderDate, then OrderID
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 |
|---|---|---|---|---|---|---|---|
| 0008 | Lena Mensah | North | Delta Kite | 6 | 59.69 | 2026-02-03 | Complete |
| 0004 | Viktor Duarte | North | Box Kite | 9 | 40.75 | 2026-04-16 | Pending |
| 0005 | Omar Uddin | South | Delta Kite | 1 | 46.82 | 2026-04-17 | Complete |