Instruction Write a query to return the number of productive and less-productive actors. The order of your results doesn't matter. Definition productive: appeared in >= 30 films. less-productive: appeared in <30 films.

Question 41

Productive actors vs less-productive actors

Unsolved Hard Lecture

Premium Access

***********

***** * ***** ** ****** *** ****** ** ********** *** ****-********** ******.
*** ***** ** **** ******* *****'* ******.

**********

Table 1: actor

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

Table 2: film_actor

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

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

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.

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%
#53. Movie groups by rental income	Hard		11%
#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%