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