Question

You want to create a list of managers and the number of employees reporting to them. Write an Oracle SQL query to retrieve managers’ names and the count of employees reporting to each manager.

Answer 1

SELECT m.employee_name AS manager_name, COUNT(e.employee_id) AS num_employees

FROM employees e

JOIN employees m ON e.manager_id = m.employee_id

GROUP BY m.employee_name;