You are viewing a single comment's thread. Return to all comments →
select C.company_code, C.founder, count(distinct LM.lead_manager_code), count( distinct SM.senior_manager_code), count(distinct M.manager_code), count( distinct E.employee_code) from Company as C join Lead_Manager as LM on C.company_code=LM.company_code join Senior_Manager as SM on LM.lead_manager_code = SM.lead_manager_code join Manager as M on SM.senior_manager_code = M.senior_manager_code join Employee as E on M.manager_code=E.manager_code group by C.company_code, C.founder order by C.company_code Asc;
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 →