Business Context
Gainwell Technologies needs a quarterly view of medical procedure utilization across state Medicaid programs. Analysts must identify the procedures most frequently billed in each provider state.
Task
Assume the reporting date is August 29, 2026, so the last completed calendar quarter is April 1 through June 30, 2026. Write a PostgreSQL query that returns the top three billed procedures per state.
Requirements
- Join claims to providers, claim lines, and medical procedures.
- Include only claim lines with
billing_status = 'BILLED' during the last completed quarter.
- Count billed claim lines for each state and procedure.
- Rank procedures independently within each state and return ranks 1 through 3.
- Sort by state, billed count descending, and procedure code for deterministic tie handling.
