Remove salary and email before sharing a roster (logistics)
Share a staff list with managers without salary or email columns.
- Level
- beginner
- Time
- ~5 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Remove named columns while keeping every other column, including ones added later.
Harbour Freight is a fictional logistics firm. HR exports its roster from the payroll system before each review cycle.
Steps
- Remove the
SalaryandEmailcolumns. - Keep all other columns in their original order.
Your result must
- No Salary or Email column
- All other columns kept, in source order
- Every employee row kept
Input
- Roster (table)
- EmpID: text
- FirstName: text
- LastName: text
- Department: text
- City: text
- Salary: number
- StartDate: text
- Manager: text (nullable)
- Email: text
Expected output columns
EmpID (text), FirstName (text), LastName (text), Department (text), City (text), StartDate (text), Manager (text (some rows null))
| EmpID | FirstName | LastName | Department | City | StartDate | Manager |
|---|---|---|---|---|---|---|
| E100 | Goran | Okafor | Operations | Westmere | 2018-05-16 | null |
| E101 | Nia | Lindqvist | Finance | Riverton | 2019-05-12 | E100 |
| E102 | Omar | Uddin | Operations | Millbrook | 2017-12-15 | null |