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.
Single-table projection from the department dimension — no joins, no aggregation.
Three explicit columns in the SELECT list (the three Dr. Okafor named). No `*`, no filter.
Every department row should appear; the table is small enough that no LIMIT is needed.