Unlock this Uber 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
-
*** ******** *** ********* ** ***** 10 *****, ******* ***** ******* *******, *** ****** *** *** 3 *** ****** 3.
-
****** *****: ***** **: 1 **** 0
-
*** * ***** ****** ** ******** ** *** ******* ** '*** 3', ** '****** 3'.
Table 1:
trip
**** ***** *** ***** **** **** ********.
***_**** | ***_****
--------------------+-------------------
****_** | ******
**** | ****
****_*****_** | *********
********_***_*** | ***
*****_***_*** | ***
**_********_******* | *******
**_********* | *******
**_****_**** | *******
****_** | ******
**********_** | ******
*******_** | ******
**** | ****
******* | *******(2)
******* ******** ***** * **** *** ********, ****** ***** ** ** ***** ****.
***_**** | ***_****
--------------------+-------------------
****_** | ******
********_** | ******
******* | ****
*****_** | *******