Daily Cancellation Rate

For each request date return the percentage of rides that were cancelled, rounded to two decimals. Order by request_date.

Table schema

Rides(id INT PRIMARY KEY, request_date DATE, status VARCHAR(20))

Sample data

id | request_date | status
1 | 2026-04-01 | completed
2 | 2026-04-01 | cancelled
3 | 2026-04-01 | completed
4 | 2026-04-02 | cancelled