HR-SQL New Companies

1 개요

HR-SQL New Companies

해커랭크 SQL

문제	DB2	MS SQL	MySQL	Oracle
HR-SQL Advanced Select e
HR-SQL Type of Triangle
HR-SQL The PADS
HR-SQL Occupations
HR-SQL Binary Tree Nodes
HR-SQL New Companies

4 MySQL

SELECT company_code, founder,
(SELECT COUNT(DISTINCT lead_manager_code) FROM Lead_Manager WHERE company_code=C.company_code),
(SELECT COUNT(DISTINCT senior_manager_code) FROM Senior_Manager WHERE company_code=C.company_code),
(SELECT COUNT(DISTINCT manager_code) FROM Manager WHERE company_code=C.company_code),
(SELECT COUNT(DISTINCT employee_code) FROM Employee WHERE company_code=C.company_code)
FROM Company C
ORDER BY company_code;