You are viewing a single comment's thread. Return to all comments →
MySQL
select A.company_code , A.founder , (select count(distinct lead_manager_code) from lead_manager where A.company_code = company_code) , (select count(distinct senior_manager_code) from senior_manager where A.company_code = company_code) , (select count(distinct manager_code) from manager where A.company_code = company_code) , (select count(distinct employee_code) from employee where A.company_code = company_code) from company as A 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 →
MySQL