Alegeus needs to review the largest approved reimbursement claims across benefit categories. Write a PostgreSQL query that returns every claim tied for the maximum eligible amount in its category.
Requirements
- Include only approved claims submitted during calendar year 2025.
- Include claims belonging to active members and exclude rows with a missing claim amount.
- Return all ties for the maximum claim amount in each category, along with the category, claim ID, member name, and maximum amount.
- Order the results by category ID and claim ID.
Representative Data
The data includes tied maximums, denied claims, inactive members, unmatched members, null amounts, zero amounts, and claims outside the requested year.
