SELECT all from a dimension
Pull the full roster from `dim_workers` sorted by hire_date ascending. I want to see worker_id, worker_name, role, shift_preference.
| Column | Type | Key |
|---|---|---|
| worker_id | INT | PK |
| worker_name | TEXT | |
| hire_date | TEXT | |
| role | TEXT | |
| shift_preference | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Single-table SELECT.
ORDER BY hire_date ASC.
Project four columns.