The Number of Employees Which Report to Each Employee.md

⚙문제보기

🔎문제 풀이 MySQL

SELECT e1.employee_id, e1.name, COUNT(*) reports_count, ROUND(AVG(e2.age), 0) average_age
FROM Employees e1 JOIN Employees e2
ON e1.employee_id = e2.reports_to
GROUP BY 1
ORDER BY 1;