Interview Guides
You are given Waymo ride activity and Waymo Driver vehicle status logs. Write a SQL query to find the average idle time in minutes per vehicle for vehicles operating in a specific geographic zone, using 'Downtown' as the target zone.
Treat a vehicle as idle when its status is 'idle'. Only count idle status records that fall between a ride's end time and the next ride's start time for the same vehicle. Return one row per vehicle in the target zone, along with its average idle time, ordered from highest to lowest average idle time.
