We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT c.company_code, c.founder,
(SELECT COUNT(DISTINCT lead_manager_code) FROM lead_manager AS l WHERE l.company_code = c.company_code ),
(SELECT COUNT(DISTINCT senior_manager_code) FROM senior_manager AS s WHERE s.company_code = c.company_code ),
(SELECT COUNT(DISTINCT manager_code) FROM manager AS m WHERE m.company_code = c.company_code ),
(SELECT COUNT(DISTINCT employee_code) FROM employee AS e WHERE e.company_code = c.company_code )
FROM company AS c ORDER BY c.company_code ASC;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
New Companies
You are viewing a single comment's thread. Return to all comments →
SELECT c.company_code, c.founder, (SELECT COUNT(DISTINCT lead_manager_code) FROM lead_manager AS l WHERE l.company_code = c.company_code ), (SELECT COUNT(DISTINCT senior_manager_code) FROM senior_manager AS s WHERE s.company_code = c.company_code ), (SELECT COUNT(DISTINCT manager_code) FROM manager AS m WHERE m.company_code = c.company_code ), (SELECT COUNT(DISTINCT employee_code) FROM employee AS e WHERE e.company_code = c.company_code ) FROM company AS c ORDER BY c.company_code ASC;