Question 184

Top 5 movies by watch time

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
  • ***** * ***** ** ****** *** *** ****** ** *** ***** ***** ****.

  • *** ****** ** ***** ******* *** * ***** ****** 28 **** ** *** *******.

*** ****:

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

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

Table 1: netflix_content

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

Table 2: 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.