728x90
New Companies
-
NEW Companies<HackerRank> 2023. 7. 14. 21:13
NEW Companies -- MYSQL SELECT e.company_code, c.founder, count( DISTINCT e.lead_manager_code ), count( DISTINCT e.senior_manager_code ), count( DISTINCT e.manager_code ), count( DISTINCT e.employee_code ) FROM Employee e, Company c WHERE e.company_code = c.company_code GROUP BY company_code, founder; -- oracle, db2 select c.company_code, c.founder, count(distinct e.lead_manager_code), count(dist..