Uber Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Analyze User Purchase Behavior in Online Marketplace Data
user_events +----------+------------+---------------------+-------------+ | user_id | event_type | event_timestamp | product_id | +----------+--...
Calculate January-2024 SF Promotion Impact Using SQL Queries
campaign_users +---------+-----------+ | user_id | treatment | +---------+-----------+ | 1001 | control | | 1002 | test | | 1003 | con...
Write SQL for active counts and YTD top driver
Given the following schema and sample data, write SQL to: (a) return the total count of active riders and active drivers on the platform; (b) return t...
Write SQL and Pandas for Uber Trips
Assume 'today' = 2025-09-01. You are given the following schema and small ASCII samples. Tables - riders(rider_id, name, signup_date) - drivers(driver...
Compute ETA shift and conversion uplift
Use PostgreSQL (SQL) and brief Python pseudocode. Assume 'today' is 2025-09-01. Schema: - trips(trip_id BIGINT, request_ts TIMESTAMP, city_id INT, rid...
Write SQL/Python for CTR analytics
Part A — SQL (use the schema and sample data below): Compute 48-hour unique CTR for campaign_id=100 by variant, deduplicating to the earliest send per...
Clean, split, merge, and aggregate with pandas
Given two CSVs, use pandas to clean, split strings, merge, and aggregate. drivers.csv driver_id,name,signup_city D1,Jane Doe,SF D2,Mark S,NYC D3,A...
Write SQL for fares and age-band counts
You have two tables. Schema: - drivers(driver_id VARCHAR PRIMARY KEY, name VARCHAR, date_of_birth DATE) - trips(trip_id VARCHAR PRIMARY KEY, driver_id...