#366 Employee Count by Department

Companies:

Sberbank

Themes:

SQLJoinsPractice

Display a list containing the department name and the number of employees in it. If a department has no employees, the department name must still be displayed with null or 0:

dep
id | name
...

emp
id | id_dep | fio
...

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.