Average ride duration, by month
Ops wants to track how ride duration trends over time. For each month, compute the average ride duration in minutes.
Return month_start and avg_duration_minutes (rounded to 1 decimal place), ordered chronologically.
Schema
▸rides
| id | INT |
| driver | TEXT |
| ride_start | TIMESTAMP |
| ride_end | TIMESTAMP |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime