Drivers With Multiple Completed Rides in a Day

Return each (driver_id, day) pair that has more than one completed ride. Order by day, driver.

Table schema

Rides(id INT PRIMARY KEY, day DATE, driver_id INT, status VARCHAR(10), fare INT, km REAL)

Sample data

id | day | driver_id | status | fare | km
1 | 2026-06-01 | 10 | completed | 120 | 5.0
2 | 2026-06-01 | 10 | cancelled | 0 | 0.0
3 | 2026-06-01 | 11 | completed | 200 | 8.0
4 | 2026-06-02 | 10 | completed | 90 | 3.0
5 | 2026-06-02 | 11 | cancelled | 0 | 0.0
6 | 2026-06-02 | 11 | cancelled | 0 | 0.0
7 | 2026-06-02 | 12 | completed | 150 | 6.0
8 | 2026-06-02 | 12 | completed | 70 | 2.0