Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Vehicle Mode Duration by Trip

Medium

JoinsData WranglingGroup ByCase When

Problem

Task

You are given Waymo Driver state-change logs and trip boundaries. Write a PostgreSQL query to calculate, for each trip, the total time the vehicle spent in autonomous mode versus manual mode. Treat each state row as effective until the next state change within the same trip; for the final state in a trip, use the trip end time. Ignore rows where the state is NULL.

Problem

Task

You are given Waymo Driver state-change logs and trip boundaries. Write a PostgreSQL query to calculate, for each trip, the total time the vehicle spent in autonomous mode versus manual mode. Treat each state row as effective until the next state change within the same trip; for the final state in a trip, use the trip end time. Ignore rows where the state is NULL.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Waymo

Average Vehicle Idle Time by ZoneMedium

Waymo

Top Daily Rides by VehicleMedium

Waymo

Top Rider Percentile by DistanceMedium

Vehicle Mode Duration by Trip | Dataford Interview Questions