Table 1: customer
***_**** | ***_**** -------------+-------------------------- ********_** | ******* *****_** | ******** *****_**** | **** ****_**** | **** ***** | **** *******_** | ******** ********** | ******* ******_**** | **** ****** | *******
Question 78
Premium Access
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
************:
********_** ** (1,2,3,4,5,6,7,8,9,10)****
*****(4) ** ****** *********.**** ****_******* ** (
****** *.********_**,
***(*.*****_**) ** *****_**, -- *** ******** *** **** ****** ** *** *****
*****(*) ** ***_******* ****
****** *
***** **** ******** *
** *.********_** = *.********_**
***** ** *.********_**
)
Table 1: customer
***_**** | ***_**** -------------+-------------------------- ********_** | ******* *****_** | ******** *****_**** | **** ****_**** | **** ***** | **** *******_** | ******** ********** | ******* ******_**** | **** ****** | *******
Table 2: 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.
10:00
Run your query to preview results here.