Solved programming problem

For each department_id, show the no of employees in that department from the employees table

Source code

SELECT DEPARTMENT_ID, COUNT(EMPLOYEE_ID)

FROM employees

GROUP BY DEPARTMENT_ID;
Join the discussion

Add your comment