Fix a query whose steps point at the wrong step (kite shop)
A step was renamed and the next step still refers to the old name. Repair the chain so the query runs.
- 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
Understand that each applied step names the previous step, and repair a broken reference.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- The starter query fails: the
Added Revenuestep refers to a step name that no longer exists. - Fix the reference so the query keeps completed orders and adds
Revenue= Qty × UnitPrice. - Don't change what the query does, only make it run.
Your result must
- The query runs without errors
- Only Complete orders
- Revenue column added
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), Revenue (number)
| OrderID | Customer | Region | Product | Qty | UnitPrice | OrderDate | Status | Revenue |
|---|---|---|---|---|---|---|---|---|
| 0001 | Lena Okafor | South | Box Kite | 7 | 38.57 | 2026-06-07 | Complete | 269.99 |
| 0004 | Omar Castillo | South | Delta Kite | 1 | 51.98 | 2026-06-27 | Complete | 51.98 |
| 0006 | Sven Duarte | South | Stunt Kite | 4 | 51.54 | 2026-05-22 | Complete | 206.16 |