Active Drivers With Zero Completed Trips
Find all active drivers who have not completed any trips in March 2026. Return driver_id, city_id, vehicle_type, and signup_date, sorted by driver_id in ascending order.
Tables: drivers, trips
SQL practice / Uber
Free SQL interview practice
Uber SQL interview questions. All free.
4 SQL practice questions in our Uber collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy · 2 Medium · 1 Hard
Independent practice resource. Not affiliated with or endorsed by Uber.
Inside the Uber set
SQL topics you can practice.
These topics come from the questions in this set. Pick one to open the matching problems.
Window functions 3 questionsAggregation 2 questionsDates 2 questionsJoins 2 questionsCTEs 1 questionNULL handling 1 question
7-Day Rolling Average of Daily Active Drivers by City
Calculate the daily count of active drivers and the 7-day rolling average of those counts for each city. A driver is considered active on a day if they completed at least one trip that day. Return trip_date, city_id, daily_active_drivers, and rolling_7d_avg, ordered by city_id and trip_date.
Tables: trips
Top 3 Drivers by Earnings Per Online Hour in Each City
Find the top 3 drivers by earnings per online hour in each city over the last 30 days. A driver must have at least 20 online hours to be included. Earnings are calculated as fare_usd * surge_multiplier for completed trips. Return city_id, driver_id, vehicle_type, earnings_per_hour, and rnk (1-3), ordered by city_id and rnk.
Tables: drivers, trips, driver_sessions
The bank
Uber SQL questions. Start typing SQL.
4 Uber problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Active Drivers With Zero Completed TripsJoins, NULL handling, DatesEasy5 min7-Day Rolling Average of Daily Active Drivers by CityWindow functions, Aggregation, DatesMedium10 minTop 3 Drivers by Earnings Per Online Hour in Each CityWindow functions, Aggregation, JoinsHard15 minUser's Third TransactionWindow functions, CTEsMedium10 minPractice Uber SQL — 4 questions
How it works
Solve in the browser. Checked instantly.
- 1Pick a problemPractice questions for data science and analytics interviews, each with its own tables, difficulty, and time target.
- 2Write and run SQLA full database engine loads in the tab. No setup, nothing to install — query the practice dataset immediately.
- 3Submit for a verdictPass and move to the next problem. Miss and you unlock the expected output and a reference solution.
Your dataset
drivers
driver_id (INTEGER) · signup_date (DATE) · city_id (INTEGER) · vehicle_type (VARCHAR) · is_active (BOOLEAN) · rating (FLOAT)
trips
trip_id (INTEGER) · driver_id (INTEGER) · rider_id (INTEGER) · request_time (TIMESTAMP) · pickup_time (TIMESTAMP) · dropoff_time (TIMESTAMP) · status (VARCHAR) · fare_usd (FLOAT) · surge_multiplier (FLOAT)
4
Uber questions
188
questions in the full bank
$0
free access
Solve one now. Build your solved history.
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Uber SQL freeExplore SQL questions by company.
188 SQL practice questions. 23 companies. Free access to every problem.