Question 134

Expensive departments

Premium Access

Unlock this Robinhood interview question.

Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.

  • 230+ interview questions
  • Official solutions
  • SQL, Python, and R tracks
  • **** ** * ******-** ** ******** 133.

  • *****, ******** *********** **** ***** **** 5 *********.

  • **** ***** *********** ** *** ***** ****** ** *** ****** ** ********** *****.

  • ** ***** ** * ***, *** ********** **** *** ******** ****** ** ********* ****** ** *****.

  • ** **’* ***** *** ****** ** ***** * ***, *** ********** **** *** ******** ** ** ****** ****.

Table 1: department

*********** ***** *** **** **********: *****, **** *******, **, ***.

  ***_****     | ***_****
---------------+-------------------
**             | ***
****           | ******* (20)

Table 2: employee

******** ***********, ********** **** *** ** *** ***** ****** ******.

  ***_****     | ***_****
---------------+-------------------
**             | ******
****_****      | ******* (100)
**********_**  | ***
******         | *****


Sample results


        
    

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Copied
Expected results

Submit a query to compare against expected output.