Given a database schema for medical claims, write a SQL query to find the top 10 providers by total claim amount in the last 30 days.
Use the provider and claim data described in the schema. Include only claims in the rolling 30-day period and return providers in descending order of total amount.
provider_id, provider_name, and total_claim_amount.total_claim_amount descending, with provider_id ascending as the tie-breaker.| Column | Type | Description |
|---|---|---|
| provider_idPK | INT | Unique provider identifier |
| provider_name | VARCHAR(200) | Provider or organization name |
| specialty | VARCHAR(100) | Provider medical specialty |
| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique claim identifier |
| provider_id | INT | Provider associated with the claim |
| claim_amount | DECIMAL(12,2) | Billed claim amount |
| claim_date | DATE | Date the claim was submitted |