Tricky~21min

The Trip Fare That Doesn't Match the Distance

10 standard trips traveled under 1km but charged a fare over ₹500 — way out of line with normal per-km pricing, suggesting a driver manually overrode the fare. 30 more short trips also have a high fare, but their fare_type is cancellation_fee — a flat fee for a rider who cancelled after the driver arrived.

Tables you'll query

trips

What you'll learn

Aggregations & GROUP BY
Investigate this case →