#120 Departments with a Specific Number of Employees

Companies:

VTB

Themes:

SQLJoinsAggregationPractice

Display departments and their employee counts where the number of employees is greater than 50:

Department
id | name
...

Person
id | fio | department_id
...

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.