Uber·Data Scientist·Technical Phone Screen
- Given a drivers table and a trips table, write a query to return driver names whose average fare across completed trips is strictly greater than $10.00. Exclude canceled trips and null fares. Output driver name and average fare rounded to 2 decimal places, ordered by average fare descending then name ascending. Drivers with no completed trips should not appear.
- Using the same schema, count completed trips grouped by driver age bands (20 to 35 and 36 to 45) as of a specific reference date. Age must be calculated accurately using the actual calendar, not a 365-day approximation. Ignore drivers outside those two bands.
“Felt pretty confident here.”