SQL_LeetCode 1731_The Number of Employees Which Report to Each Employee 풀이 -- ORACLE, MYSQL SELECT E1.EMPLOYEE_ID , E1.NAME , COUNT(E2.EMPLOYEE_ID) AS REPORTS_COUNT , ROUND(AVG(E2.AGE)) AS AVERAGE_AGE FROM EMPLOYEES E1 JOIN EMPLOYEES E2 ON E1.EMPLOYEE_ID = E2.REPORTS_TO GROUP BY E1.EMPLOYEE_ID, E1.NAME ORDER BY E1.EMPLOYEE_ID; -- MSSQL SELECT E1.EMPLOYEE_ID , E1.NAME , COUNT(E2.EMPLOYEE_ID) AS REPORTS_COUNT , ROUND(AVG(E2.AGE * 1.0), 0) AS AVERAGE_AGE FROM EMPLOYEES E1 JOIN EMPLOYEES E2 ON E1.EM...
#
LeetCode1731_TheNumberofEmployeesWhichReporttoEachEmployee
#
SQL
#
SQL_LeetCode1731
#
SQL_LeetCode1731_TheNumberofEmployeesWhichReporttoEachEmployee
#
SQL_TheNumberofEmployeesWhichReporttoEachEmployee
