Write a SQL query to find the top 10 patients by readmission rates at Massachusetts General Hospital.
Use the patients and admissions tables. Treat is_readmission_30d = TRUE as a readmission and include only patients with at least one admission.
patient_id, patient_name, total_admissions, readmissions_30d, and readmission_rate_pct.| Column | Type | Description |
|---|---|---|
| patient_idPK | INT | Unique patient identifier |
| patient_name | VARCHAR(100) | Patient full name |
| Column | Type | Description |
|---|---|---|
| admission_idPK | INT | Unique admission identifier |
| patient_id | INT | Patient associated with the admission |
| admission_date | DATE | Date the admission began |
| is_readmission_30d | BOOLEAN | Whether the admission was a documented readmission within 30 days |