SELECT specific columns from a dimension table
Can you show me all departments — the name, type, and bed count for each? I need to understand our facility layout before the quality review kickoff this afternoon.
| Column | Type | Key |
|---|---|---|
| department_id | INT | PK |
| department_name | TEXT | |
| department_type | TEXT | |
| floor | INT | |
| bed_count | INT | |
| manager_name | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
All department info is in `dim_departments`. Dr. Okafor only asked for three specific fields
Name the three columns explicitly in your SELECT list instead of using `*`. No filter needed — there are only 12 rows
`SELECT ___, ___, ___ FROM dim_departments` — fill in the three column names Dr. Okafor asked for