Instruction Write a query to return the number of films with no rentals in Feb 2020. Count the entire movie catalog from the film table.

Prev Discuss

Question 32

Unpopular movies

Unsolved Hard Lecture

Premium Access

Unlock this premium interview question.

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

***********

***** * ***** ** ****** *** ****** ** ***** **** ** ******* ** *** 2020.
***** *** ****** ***** ******* **** *** **** *****.

Table 1: film

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

Table 2: inventory

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

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

Table 3: 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 IN, BETWEEN, LIKE, CASE WHEN Questions

Browse Topic Set

Question	Level	Company	FTPR
#178. Members who worked at both Microsoft and Google	Medium	linkedin	34%
#177. Purchases by platform report	Medium	amazon	10%
#176. Employees' annual bonus	Easy	amazon	12%
#160. Sellers with no sales by day	Hard	ebay	11%
#156. Cancellation rate by unbanned users	Hard	lyft	15%
#155. Driver with the highest cancellation rate	Easy	lyft	24%
#151. Salary report	Easy	dropbox	18%
#138. Happy restaurants	Easy	doordash	14%
#136. Extremely late orders	Easy	doordash	11%
#131. Churned accounts	Hard	affirm	10%
#102. Histogram by visit session duration	Hard	google	17%
#35. Film length report	Easy		27%
#34. Stocked up movies	Easy		27%
#33. Returning customers	Medium		8%
#31. Movies that have not been returned	Easy		26%
#30. Inactive customers in May	Easy		22%
#29. Second highest spend customer	Medium		14%
#28. Film with the second largest cast	Medium		26%
#27. Film with the largest cast	Easy		27%
#26. Second shortest film	Easy		30%
#25. Shortest film	Easy		46%
#24. Films with more than 10 actors	Medium		19%
#22. Average cost per rental transaction	Easy		42%
#15. Fast movie watchers vs slow watchers	Hard		6%