Write a query to identify the top 10 clients by claims volume at Collective Health.
Use the provided clients and claims tables. Claims volume is the number of claim records associated with each client. Include clients with no claims when determining the ranked results.
client_id, client_name, and claims_volume.claims_volume descending and client_id ascending to break ties.| Column | Type | Description |
|---|---|---|
| client_idPK | INT | Unique identifier for the Collective Health client |
| client_name | VARCHAR(150) | Client organization name |
| Column | Type | Description |
|---|---|---|
| claim_idPK | INT | Unique identifier for a claim |
| client_id | INT | Client associated with the claim |
| claim_date | DATE | Date the claim was submitted |