Top Denied Claims Providers | Dataford Interview Questions

Write a SQL query to identify the top five medical providers with the highest volume of denied claims in a given month.

Use the provided claims and medical_providers tables. The selected month is March 2025 in the sample data; the query should make the month boundaries easy to change.

Output

One row per qualifying medical provider with provider_id, provider_name, and denied_claim_count.
Include only denied claims within the selected month.
Return at most five rows, ordered by denied count descending, then provider ID ascending to break ties.

Schema

medical_providers

Column	Type	Description
provider_idPK	INT	Unique medical provider identifier
provider_name	VARCHAR(150)	Display name of the medical provider
provider_type	VARCHAR(50)	Type of medical provider

claims

Column	Type	Description
claim_idPK	INT	Unique claim identifier
provider_id	INT	Medical provider associated with the claim
claim_date	DATE	Date the claim was submitted
claim_status	VARCHAR(30)	Current adjudication status of the claim

Your question is Top Denied Claims Providers. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem