Collections by department

Challenge

Sum billed and paid claim amounts for each department.

Business context

Revenue cycle compares what each department billed with what payers have paid. A claim that has not been priced yet contributes zero paid dollars, not a missing department.

Instructions

Return department, billed_cents, and paid_cents. Sum billed_cents and treat a null paid_cents as zero. Sort by paid_cents descending, then department.

Schema

Sample rows