Interview Guides
You are given Waymo rider trip data and rider profile data. Write a PostgreSQL query to identify the top 5% of riders by total distance traveled and return each qualifying rider with their average trip duration in minutes. Treat total distance as the sum of all completed trip distances per rider, and average duration as the average of completed trip durations only. If the 5% cutoff falls between riders, include riders whose percentile rank places them in the top 5%.
