Question 126

Top 3 restaurants

Premium Access

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
  • ***** * ***** ** ****** *** *** 3 *********** ** **** **** ** ******* ******.
  • **** ********** **** **** ********* ** ***** 10 *****. 
  • **** ********* *** ******* ******, ******* *********** **** **** **** 10 *****.
  • ***** *** ******: *****-**: 1 ********* 0.

Table 1: trip

**** ***** *** ***** **** **** ********.

  ***_****          | ***_****
--------------------+-------------------
****_**             | ******
****                | ****
****_*****_**       | *********
********_***_***    | ***
*****_***_***       | ***
**_********_******* | *******
**_*********        | ******* 
**_****_****        | *******
****_**             | ******
**********_**       | ******
*******_**          | ******
****               | ****
*******             | *******(2)

Table 2: trip_rating

******* ******** ***** * **** *** ********, ****** ***** ** ** ***** ****.

  ***_****          | ***_****
--------------------+-------------------
****_**             | ******
********_**         | ******
*******             | ****
*****_**            | *******

Sample results


        
    

Last Submission

postgres

No 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.