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.
- Prepare
- SQL
- Advanced Select
- New Companies
- Discussions
New Companies
New Companies
Sort by
recency
|
2785 Discussions
|
Please Login in order to post a comment
select C.company_code, C.founder, count(distinct E.lead_manager_code), count( distinct E.senior_manager_code), count(distinct E.manager_code), count( distinct E.employee_code) from Company as C join Employee as E on C.company_code=E.company_code group by C.company_code, C.founder order by C.company_code Asc;
# ORACLE SELECT CO.COMPANY_CODE, CO.FOUNDER, COUNT( DISTINCT(L.LEAD_MANAGER_CODE)) N_O_LEA, COUNT( DISTINCT(S.SENIOR_MANAGER_CODE)) N_O_SENIO, COUNT( DISTINCT(M.MANAGER_CODE)) N_O_MANA, COUNT( DISTINCT(E.EMPLOYEE_CODE)) N_O_EMPLO FROM COMPANY CO JOIN LEAD_MANAGER L ON(CO.COMPANY_CODE = L.COMPANY_CODE ) JOIN SENIOR_MANAGER S ON(CO.COMPANY_CODE = S.COMPANY_CODE) JOIN MANAGER M ON(CO.COMPANY_CODE = M.COMPANY_CODE) JOIN EMPLOYEE E ON(CO.COMPANY_CODE = E.COMPANY_CODE) GROUP BY CO.COMPANY_CODE, CO.FOUNDER ORDER BY CO.COMPANY_CODE ASC;