Write a SQL query to extract specific data from a healthcare database at Cambia Health Solutions.
Using the provided claims, members, and providers tables, return providers with at least two paid claims in calendar year 2025. Include only claims associated with an existing member and provider.
provider_id, provider_name, specialty, total_paid_claims, unique_members, total_paid_amount, avg_billed_amount, and payment_band.total_paid_amount descending, then provider_id ascending.| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique claim identifier |
| member_id | INT | Member associated with the claim |
| provider_id | INT | Provider who submitted the claim |
| service_date | DATE | Date healthcare service was provided |
| claim_status | VARCHAR(20) | Claim processing status |
| billed_amount | DECIMAL(10,2) | Amount billed on the claim |
| paid_amount | DECIMAL(10,2) | Amount paid for the claim |
| Column | Type | Description |
|---|---|---|
| member_idPK | INT | Unique member identifier |
| member_name | VARCHAR(100) | Member display name |
| state | VARCHAR(2) | Member residence state |
| Column | Type | Description |
|---|---|---|
| provider_idPK | INT | Unique provider identifier |
| provider_name | VARCHAR(120) | Provider organization name |
| specialty | VARCHAR(80) | Provider clinical specialty |