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
- ***** * ***** ** ****** *** ******* ********** **** ** ****.
- ********** ****: ****** ** ********* ***** * 100.0 / ***** ****** ** *****
Table 1:
merchant
* ********* ***** *** *** ******* ******** **** ** * **********.
***_**** | ***_****
-----------------+-------------------
** | ******
***********_*** | *****
*****_****** | *******(5)
********_****_** | ******
**_****** | *******
*****_******_** | *********
**** | ****
******* | *******(2)
Table 2:
trip
**** ***** *** ***** **** **** ********.
***_**** | ***_****
--------------------+-------------------
****_** | ******
**** | ****
****_*****_** | *********
********_***_*** | ***
*****_***_*** | ***
**_********_******* | *******
**_********* | *******
**_****_**** | *******
****_** | ******
**********_** | ******
*******_** | ******
**** | ****
******* | *******(2)