leetcode

0 SELECT M.employee_id,

1 M.name,

2 COUNT(E.employee_id) AS reports_count,

3 ROUND(AVG(E.age), 0) AS average_age

4 FROM Employees M

5 LEFT JOIN Employees E

6 ON M.employee_id = E.reports_to

7 GROUP BY M.employee_id

8 HAVING COUNT(E.employee_id) > 0

9 ORDER BY M.employee_id