Table 1: rideshare_trips
***_**** | ***_**** -----------------+--------------------- ** | ****** ******_** | ****** ******_** | ****** ****** | *******(20) -- '*********', '********* ** ******', '********* ** ******' *******_** | ****
Question 157
Number of trips before a driver got banned
Premium Access
Unlock this Lyft interview question.
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
- 230+ interview questions
- Official solutions
- SQL, Python, and R tracks
- ***** * ***** ** ****** *** ******* ****** ** ***** ****** * ****** ** ******.
- **** ***** ******* *** ***** *** ******.
Table 2: rideshare_users
*** ***** ** *** *********** ********. ** * **** *** *** *****, **** **** **** ******** ****, *.*., *** *** *** *** ******, *** *** *** *** ****** **** ********* ****_**.
***_**** | ***_**** -----------------+--------------------- ****_** | ****** **** | *******(10) -- '******' ** '******' ******_** | ********* -- **** *** **** ******* ** ******* ******_** | ********* -- **** *** **** ******** ** ******, **** ** *** ******
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Copied
Expected results
Submit a query to compare against expected output.
Interview timer
Recommended interview pacing
Easy: 5 min for direct warm-up style questions.
Medium: 10 min for multi-step interview queries.
Hard: 15 min for layered questions with tighter time pressure.
A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.
10:00
Your results
Run your query to preview results here.