Instruction Write a query to return the number of films in 3 separate groups: high, medium, low. The order of your results doesn't matter. Definition high: revenue >= $100. medium: revenue >= $20, <$100 . low: revenue <$20. Hint If a movie has no re…

Prev Discuss

Question 53

Movie groups by rental income

Unsolved Hard Lecture

Premium Access

Unlock this premium interview question.

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

***********

***** * ***** ** ****** *** ****** ** ***** ** 3 ******** ******: ****, ******, ***.
*** ***** ** **** ******* *****'* ******.

**********

****: ******* >= $100.
******: ******* >= $20, <$100 .
***: ******* <$20.

****

** * ***** *** ** ****** *******, ** ******* ** *** *** *****

Table 1: film

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

Table 2: inventory

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

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

Table 3: payment

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

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

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

15:00

Timer

Your results

Run your query to preview results here.

More OUTER JOIN Questions

Browse Topic Set

Question	Level	Company	FTPR
#194. Daily active users report for new market	Easy	snap	20%
#191. Number of replies by group	Medium	twitter	18%
#172. Comments distribution	Hard	facebook	13%
#168. Average number of streams in the US	Medium	tiktok	13%
#140. Daily sales of restaurant 100011	Hard	doordash	8%
#118. Daily bookings in the US	Hard	airbnb	5%
#100. Advertiser ROI	Medium	facebook	8%
#56. Total number of actors	Easy		30%
#55. Busy days and slow days	Medium		10%
#54. Customer groups by movie rental spend	Medium		20%
#52. Movies cast by movie only actors	Easy		11%
#51. Movie only actor	Easy		37%
#45. Movie inventory optimization	Hard		9%
#44. In-demand vs not-in-demand movies	Medium		6%
#43. Customers who rented vs. those who did not	Medium		8%
#42. Films that are in stock vs not in stock	Medium		12%
#41. Productive actors vs less-productive actors	Hard		7%