Question 183

Top 5 movies by number of watchers

Premium Access

Unlock this Netflix 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
  • **** ** * ******-** ******** ** #182
  • ***** * ***** ** ****** *** *** 5 ****** (********* ***) ***** ** *** ****** ** ********.
  • *** * ***** *****, **** ******* ******** **** ******* ** ***** 10 ******* (>600 *******) ** *** ***** ***** *** ***** *** ***** ******** ****** 28 ****.

*** ****:

******** ******* ** *** *****’* **** ********** ** ******* *****, *****., ******** ****** ****** ********* *******’* **** ******* ****** *** ****** ** **** *** ****** ** ******** **** ******* **** ** ***** ***** 28 **** ** *** ********* ******** *** *** ****** ** ***** **** **** **** ******* ** **** *********.

*****://*******.***/2021/*******/****/*******-****-*******-**-*****-******-1235075301/

Table 1: netflix_account

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

Table 2: netflix_content

 ***_****          | ***_****
-------------------+---------------------
 *******_**        | ******
 *******_****      | ********* *******(10) -- ****** ** ** *****
 ********_******** | ********* *******(2) -- '**',  '**', '**', '**'
 *******_****      | ****

Table 3: netflix_daily_streaming

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

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

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.