mahir_data
mediumGrab · date-timePro

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
idINT
driverTEXT
ride_startTIMESTAMP
ride_endTIMESTAMP

Pro

The example input, expected output, and walkthrough for this question unlock with a Pro plan.

Pro

This is a Pro question

Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.

See Pro plans