leetcode

Solution to some Leetcode problems written in C++

git clone git://git.dimitrijedobrota.com/leetcode.git

1731.sql (275B)

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