Who asked: the revenue cycle director at Cedar Ridge Health, a fictional health system.
Why: the finance committee says denials look high and wants to know where to start. Before anyone fixes anything, the director needs the rate defined properly, what drives it, and the dollars at stake for each team.
The data: hd_claims (one claim per encounter: paid, denied or pending, with the denial reason and amounts), hd_payers and hd_encounters, January to June 2026.
What done looks like: the denial rate over adjudicated claims next to the share of dollars denied; denials by reason, by payer and by kind of care; the denied dollars for each team that can fix them; and one recommendation on where to start.
A case study in six steps on Cedar Ridge's claims. Each SQL step answers one of the director's questions; the last step turns the findings into a recommendation.