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.
  1. Prepare
  2. SQL
  3. Advanced Select
  4. New Companies
  5. Discussions

New Companies

  • jr_delaoz
     + 0 comments

    My solution

    SELECT company.company_code, company.founder, (SELECT COUNT(DISTINCT lead_manager_code) FROM lead_manager WHERE lead_manager.company_code = company.company_code) AS total_lead_manager, (SELECT COUNT(DISTINCT senior_manager_code) FROM senior_manager WHERE senior_manager.company_code = company.company_code) AS total_senior_manager, (SELECT COUNT(DISTINCT manager_code) FROM manager WHERE manager.company_code = company.company_code) AS total_manager, (SELECT COUNT(DISTINCT employee_code) FROM employee WHERE employee.company_code = company.company_code) AS total_employee FROM company ORDER BY company.company_code ASC;