Find the three largest orders (kite shop)
Calculate each order's value and keep the three biggest, largest first.
- Level
- intermediate
- Time
- ~8 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Combine a calculated column, a descending sort and Keep Top Rows.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- Add
Value=Qty×UnitPrice. - Sort by
Valuedescending and keep the top 3 rows. - Output only
OrderID,CustomerandValue.
Your result must
- Exactly 3 rows
- Largest value first
- Columns: OrderID, Customer, Value
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), Value (number)
| OrderID | Customer | Value |
|---|---|---|
| 0009 | Zane Brandt | 502.56000000000006 |
| 0007 | Nia Yilmaz | 188.37 |
| 0006 | Yara Silva | 158.04 |