Write a SQL query to find the top 5 providers by claim volume within a specific zip code.
Assume provider ZIP codes are stored in providers and claims are stored in claims. Use ZIP code 10027 for this exercise.
provider_id, provider_name, and claim_volume.10027, ordered by claim_volume descending, with provider_id ascending as the tie-breaker.| Column | Type | Description |
|---|---|---|
| provider_idPK | INT | Unique provider identifier |
| provider_name | VARCHAR(100) | Provider or practice name |
| specialty | VARCHAR(80) | Primary medical specialty |
| zip_code | VARCHAR(5) | Provider service ZIP code |
| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique claim identifier |
| provider_id | INT | Provider associated with the claim |
| claim_date | DATE | Date the claim was submitted |
| claim_status | VARCHAR(20) | Current claim processing status |