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.
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`