Given a table of provider claims, write a query to find the top three most common billing codes per provider specialty for Oscar Health. Assume provider specialty is stored separately from claims and exclude claims without a valid provider, specialty, or billing code.
Output
- One row per qualifying specialty and billing code, with columns
specialty, billing_code, and claim_count.
- Include up to three codes per specialty, ordered by claim count descending, then billing code ascending for ties, with specialties alphabetized.
