SQL and Experiment Case Rounds

Tell me about your approach to solving a multi-round Uber case that included SQL, advanced SQL, a case study, and a product success analysis.

For the SQL portion, use the supplied Uber trips and cities tables to compare product performance during June 2026.

Output

1. One row per qualifying city and product.
2. Columns: city_name, product_type, total_requests, completed_trips, completion_rate, average_completed_fare, and completed_trip_rank.
3. Include only city-product combinations with at least two requests, rank products within each city by completed trips descending, and order by city_name, completed_trip_rank, then product_type.

Output details

• Filter requests from 2026-06-01 00:00:00 inclusive through 2026-07-01 00:00:00 exclusive.
• Count a trip as completed only when status = 'completed'.
• Calculate completion_rate as completed trips divided by total requests times 100, rounded to 2 decimal places.
• Round average_completed_fare to 2 decimal places using completed trips only.
• Return NULL for average_completed_fare when a qualifying city-product combination has no completed trips.
• Assign equal completed_trip_rank values to ties, leaving gaps after tied ranks.