Table 1: department
*********** ***** *** **** **********: *****, **** *******, **, ***.
***_**** | ***_**** ---------------+------------------- ** | *** **** | ******* (20)
Question 135
Premium Access
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
*****, ******** *********** **** ***** **** 5 *********.
**** ***** *********** ** *** ***** ****** ** *** ****** ** ********** *****.
** ***** ** * ***, *** ********** **** *** ******** ****** ** ********* ****** ** *****.
** **’* ***** *** ****** ** ***** * ***, *** ********** **** *** ******** ** ** ****** ****.
***** * ***** ** ****** *** *********** ** *** **** ***, ** ** *** *** ***** ****** ********** ***.
Table 1: department
*********** ***** *** **** **********: *****, **** *******, **, ***.
***_**** | ***_**** ---------------+------------------- ** | *** **** | ******* (20)
Table 2: employee
******** ***********, ********** **** *** ** *** ***** ****** ******.
***_**** | ***_**** ---------------+------------------- ** | ****** ****_**** | ******* (100) **********_** | *** ****** | *****
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.