Sort orders by region, then by price (kite shop)
Produce a list sorted by Region A→Z and, within each region, by UnitPrice from highest to lowest.
- Level
- beginner
- Time
- ~6 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Sort on more than one column and understand that the first sort key wins.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- Sort by
Regionascending. - Within each region, sort by
UnitPricedescending. - Keep all rows and columns.
Your result must
- Rows are in Region order A→Z
- Within a region, highest UnitPrice first
- Row order is checked for this task
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 |
|---|---|---|---|---|---|---|---|
| 0004 | Jun Uddin | East | Tail Ribbon | 1 | 34.38 | 2026-05-23 | Complete |
| 0006 | Priya Grieve | North | Tail Ribbon | 5 | 46.77 | 2026-05-02 | Complete |
| 0009 | Farah Quist | North | Box Kite | 8 | 39.28 | 2026-06-02 | Complete |