Getting everything ready for you…

Loading courses, problems and your progress. This takes just a moment.

0s

SQL practice › Joins & grouping

Employees per Department

Medium · Joins & grouping

For every department that has at least one employee, return the department name and the number of employees in it.

Hint

JOIN the tables, then GROUP BY the department.

Write your query on this page — it runs against the sample company database in your browser and is checked instantly.

Next problem: Average Salary by Department