Healthcare Analytics Path · Mission 2 of 25Starter

How many departments do we have?

SELECT specific columns from a dimension table

Back to Healthcare Analytics

The Brief

Dr. Amara OkaforChief Quality Officerslack-dm

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.

You'll practice

SELECTExploration

Tables available

dim_departments

Hints (3)

Each hint you reveal reduces the XP you can earn. Try the query first.

Hint 1

All department info is in `dim_departments`. Dr. Okafor only asked for three specific fields

Hint 2

Name the three columns explicitly in your SELECT list instead of using `*`. No filter needed — there are only 12 rows

Hint 3

`SELECT ___, ___, ___ FROM dim_departments` — fill in the three column names Dr. Okafor asked for