Instructions: Write a query to return revenue percentiles (ordered ascendingly) of the following movies within their category: film_id IN (1,2,3,4,5). For simplicity, we ignore those movies with 0 revenue Hint Use NTILE(100) to create percentiles. To save you some t…

Prev Discuss

Question 77

Movie revenue percentiles by category

Unsolved Easy Lecture

Premium Access

Unlock this premium interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

************:

***** * ***** ** ****** ******* *********** (******* ***********) ** *** ********* ****** ****** ***** ********:
****_** ** (1,2,3,4,5).
*** **********, ** ****** ***** ****** **** 0 *******

****

*** *****(100) ** ****** ***********.
** **** *** **** ****, **** ** *** *** ** ****** * *****'* ******* ** ********.

**** *****_***_**_*** ** (
    ****** 
       *.****_**,
       ***(**.********_**) ** ********_**,
       ***(*.******) ** *******
    **** **** *
    ***** **** ********* *
    ** *.****_** = *.****_**
    ***** **** ****** *
    ** *.*********_** = *.*********_**
    ***** **** ******* *
    ** *.******_** = *.******_**
    ***** **** ****_******** **
    ** **.****_** = *.****_**
    ***** ** *.****_**
)

Table 1: film

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

Table 2: film_category

* **** *** **** ****** ** *** ********

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

Table 3: inventory

**** *** ** ******, ********_** ** *** ******* *** ** **** *****.

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

Table 4: payment

***** ****** ******* ************ *****

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

Table 5: rental

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

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

5:00

Timer

Your results

Run your query to preview results here.

Question	Level	Company	FTPR
#103. Median and average session duration by day of the week	Medium	google	20%
#78. Quartiles buckets by number of rentals	Medium		25%
#67. Quartile by number of rentals	Easy		24%
#66. Movie percentiles by revenue by category	Medium		18%
#65. Movie revenue percentiles	Easy		16%

Movie revenue percentiles by category

Unlock this premium interview question.

More NTILE Questions