SQL · Uber · Hard
You are analyzing ride requests from an A/B experiment with experiment_id = 42. All request_ts values are UTC. Convert each timestamp to a calendar date with: Treat a rider as eligible only when signup_dt < 2025-07-01; join trips to riders on rider_id. Input tables trips stores one request per row and includes: riders stores one rider per row and includes: Only trips and riders are needed for the tasks below. Task 1: 7-day rolling ETA median and daily conversion Return one…
Checking your access…