You are viewing a single comment's thread. Return to all comments →
MS SQL SERVER :
SELECT C.COMPANY_CODE, C.FOUNDER, COUNT(DISTINCT LM.LEAD_MANAGER_CODE) AS [TOTAL NUMBER OF LEAD MANAGER], COUNT(DISTINCT SM.SENIOR_MANAGER_CODE) AS [TOTAL NUMBER OF SENIOR MANAGER], COUNT(DISTINCT M.MANAGER_CODE) AS [TOTAL NUMBER OF MANAGERS], COUNT(DISTINCT E.EMPLOYEE_CODE) AS [TOTAL NUMBER OF EMPLOYEES] FROM COMPANY C INNER JOIN LEAD_MANAGER LM ON C.COMPANY_CODE = LM.COMPANY_CODE INNER JOIN SENIOR_MANAGER SM ON C.COMPANY_CODE = SM.COMPANY_CODE INNER JOIN MANAGER M ON C.COMPANY_CODE = M.COMPANY_CODE INNER JOIN EMPLOYEE E ON C.COMPANY_CODE = E.COMPANY_CODE GROUP BY C.COMPANY_CODE,C.FOUNDER ORDER BY LEFT(C.COMPANY_CODE,3) 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 →
MS SQL SERVER :