Uber practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
Uber
Explore 9 Uber-tagged SQL scenarios focused on query basics, aggregation, analytics reporting.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
9
Estimated prep time
195 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Uber-tagged set.
Query basics
8
Aggregation
4
Analytics reporting
1
Date functions
1
Filtering
1
Joins
1
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Creators With Multiple 2024 Posts
Practice query basics through a Uber-tagged business scenario.
Frequent Support Callers
Practice query basics through a Uber-tagged business scenario.
2024 App Click Volume
Practice query basics through a Uber-tagged business scenario.
Question list
The current Uber-tagged list with learning objectives and your latest status.
Creators With Multiple 2024 Posts
Uber is reviewing creators with multiple 2024 posts through a portfolio scan. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Practice query basics through a Uber-tagged business scenario.
Frequent Support Callers
Use this Uber planning note to work on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort by p...
Practice query basics through a Uber-tagged business scenario.
2024 App Click Volume
Uber wants a priority review for 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort by app_id.
Practice query basics through a Uber-tagged business scenario.
Year-on-year Product Spend Growth
Use this Uber trend check to work on year-on-year product spend growth. Calculate the year-on-year growth rate for each product_id. Return report_year, produ...
Practice query basics through a Uber-tagged business scenario.
Purchase Frequency Histogram
Use this Uber scorecard to work on purchase frequency histogram. Show how many users placed each number of purchases. Return purchase_count and user_count, s...
Practice query basics through a Uber-tagged business scenario.
April Webinar Share
Uber wants a portfolio scan for april webinar share. Return the percentage of marketing touches that were webinars in April 2024, rounded to the nearest inte...
Practice query basics through a Uber-tagged business scenario.
Queue Satisfaction Averages
At Uber, analysts are preparing a readout focused on queue satisfaction averages. Return queue_name and average satisfaction_score rounded to two decimals. S...
Practice query basics through a Uber-tagged business scenario.
7. Could you describe a self-join and provide a scenario in which it would be used
A self-join is a type of join in which a table is joined to itself. To perform a self-join, you need to specify the table name twice in the FROM clause, and ...
Practice filtering through a Uber-tagged business scenario.
Consecutive Delay Streaks
Dispatch wants the longest streak of delayed service days for each driver. Return driver_id and longest_streak, where a streak counts consecutive trip_date v...
Practice query basics through a Uber-tagged business scenario.