Average Fare per Kilometre
Return the overall average fare per kilometre over completed rides, rounded to 2 decimals.
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
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.