Solved programming problem

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

Source code

SELECT DEPARTMENT_ID, COUNT(MANAGER_ID)

FROM employees

GROUP BY DEPARTMENT_ID;
Join the discussion

Add your comment