Given a table of patient appointments and a table of therapist specialties, write a query to identify which specialties have the highest cancellation rates on Headway.
Treat every appointment as part of the denominator, including appointments with a NULL status. Count only rows with status = 'cancelled' as cancellations.
specialty, appointment_count, canceled_appointments, and cancellation_rate, where the rate is a percentage rounded to two decimals.| Column | Type | Description |
|---|---|---|
| appointment_idPK | INT | Unique appointment identifier |
| therapist_id | INT | Identifier of the therapist assigned to the appointment |
| appointment_date | DATE | Date of the appointment |
| status | VARCHAR(20) | Appointment status |
| Column | Type | Description |
|---|---|---|
| therapist_idPK | INT | Unique therapist identifier |
| specialty | VARCHAR(100) | Primary specialty associated with the therapist |