Use GROUP BY to explore data distribution and spot inconsistencies
What's our payer mix? Show each insurance type and how many patients we have for each. This tells me a lot about our patient population — Medicare patients have very different needs from commercial insurance patients.
| Column | Type | Key |
|---|---|---|
| patient_id | INT | PK |
| first_name | TEXT | |
| last_name | TEXT | |
| date_of_birth | TEXT | |
| gender | TEXT | |
| insurance_type | TEXT | |
| zip_code | TEXT | |
| primary_language | TEXT | |
| is_deceased | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Everything you need is in `dim_patients` — no joins. One row per insurance type with a patient count
Group the patient rows by insurance_type, count each group, and sort largest-first
`SELECT insurance_type, ___(*) AS patient_count FROM dim_patients GROUP BY ___ ORDER BY ___ DESC`