Rename and reorder columns for a finance report (kite shop)
Give columns business-friendly names and put them in the order finance expects.
- 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
Rename columns and set an explicit column order without changing any values.
Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.
Steps
- Keep
OrderDate,OrderID,CustomerandUnitPrice. - Rename them to
Order Date,Order Number,Customer NameandUnit Price. - Order the columns:
Order Number,Order Date,Customer Name,Unit Price.
Your result must
- Exactly four columns in the stated order
- Values are unchanged
- Still works when the export gains a column
Input
- Orders (table)
- OrderID: text
- Customer: text
- Region: text
- Product: text
- Qty: number
- UnitPrice: number
- OrderDate: text
- Status: text
Expected output columns
Order Number (text), Order Date (text), Customer Name (text), Unit Price (number)
| Order Number | Order Date | Customer Name | Unit Price |
|---|---|---|---|
| 0001 | 2026-03-03 | Priya Grieve | 16.53 |
| 0002 | 2026-04-21 | Rosa Lindqvist | 58.72 |
| 0003 | 2026-06-21 | Sven Zielinski | 14.18 |