MySQL7 [HacKerRank SQL] New Companies- MYSQL 그냥 풀기 SELECT C.company_code, C.founder, COUNT(DISTINCT L.lead_manager_code), COUNT(DISTINCT S.senior_manager_code), COUNT(DISTINCT M.manager_code), COUNT(DISTINCT E.employee_code) FROM Company AS C, Lead_Manager AS L, Senior_Manager AS S, Manager AS M, Employee AS E WHERE C.company_code = L.company_code AND L.lead_manager_code = S.lead_manager_code AND S.senior_manager_code = M.senior_manager_co.. 2021. 2. 19. 이전 1 2 다음