Solved programming problem

For each manager_id, show the no of employees under his supervision from the employees table

Source code

SELECT MANAGER_ID, COUNT(EMPLOYEE_ID)

FROM employees

GROUP BY MANAGER_ID;
Join the discussion

Add your comment