Claim denial rate by department

Challenge

Calculate the percent of claims denied in each department.

Business context

Revenue cycle compares denial rates, not just denied dollars. A submitted claim is not a denial. Rate is denied claims divided by all claims, as a whole-number percent.

Instructions

Return department, claims, denied_claims, and denial_percent. denial_percent is denied claims times 100, divided by the number of claims, using integer division. Sort by denial_percent descending, then department.

Schema

Sample rows