Question 77
Premium Access
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
************:
****_** ** (1,2,3,4,5).****
*****(100) ** ****** ***********.**** *****_***_**_*** ** (
******
*.****_**,
***(**.********_**) ** ********_**,
***(*.******) ** *******
**** **** *
***** **** ********* *
** *.****_** = *.****_**
***** **** ****** *
** *.*********_** = *.*********_**
***** **** ******* *
** *.******_** = *.******_**
***** **** ****_******** **
** **.****_** = *.****_**
***** ** *.****_**
)
Table 1: film
***_**** | ***_**** ----------------------+-------------------------- ****_** | ******* ***** | **** *********** | **** *******_**** | ******* ********_** | ******** ********_********_** | ******** ******_******** | ******** ******_**** | ******* ****** | ******** ***********_**** | ******* ****** | ****
Table 2: film_category
* **** *** **** ****** ** *** ********
***_**** | ***_**** -------------+-------------------------- ****_** | ******** ********_** | ********
Table 3: inventory
**** *** ** ******, ********_** ** *** ******* *** ** **** *****.
***_**** | ***_**** --------------+-------------------------- *********_** | ******* ****_** | ******** *****_** | ********
Table 4: payment
***** ****** ******* ************ *****
***_**** | ***_**** --------------+-------------------------- *******_** | ******* ********_** | ******** *****_** | ******** ******_** | ******* ****** | ******* *******_** | ********* **** **** ****
Table 5: rental
***_**** | ***_**** --------------+-------------------------- ******_** | ******* ******_** | ********* **** **** **** *********_** | ******* ********_** | ******** ******_** | ********* **** **** **** *****_** | ********
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Submit a query to compare against expected output.
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
Run your query to preview results here.