You are viewing a single comment's thread. Return to all comments →
Using with clause
WITH cntlm AS ( SELECT company_code, COUNT(DISTINCT lead_manager_code) lmc FROM lead_manager GROUP BY company_code ), cntsm AS ( SELECT company_code, COUNT(DISTINCT senior_manager_code) smc FROM senior_manager GROUP BY company_code ), cntm AS ( SELECT company_code, COUNT(DISTINCT manager_code) mc FROM manager GROUP BY company_code ), cnte AS ( SELECT company_code, COUNT(DISTINCT employee_code) ec FROM employee GROUP BY company_code ) SELECT company.company_code, company.founder, lmc, smc, mc, ec FROM company JOIN cntlm ON cntlm.company_code = company.company_code JOIN cntsm ON cntsm.company_code = company.company_code JOIN cntm ON cntm.company_code = company.company_code JOIN cnte ON cnte.company_code = company.company_code ORDER BY company_code;
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 →
Using with clause