Question 2 (New Companies)

-- Medium
-- Question 2 (New Companies):

SELECT comp.Company_code,
       comp.Founder,

  (SELECT COUNT(DISTINCT Lead_Manager_Code) FROM Lead_Manager LEAD WHERE LEAD.Company_code = comp.Company_code),
  
  (SELECT COUNT(DISTINCT Senior_Manager_Code) FROM Senior_Manager SENIOR WHERE SENIOR.Company_code = comp.Company_code),

  (SELECT COUNT(DISTINCT Manager_Code) FROM Manager MANAGER WHERE MANAGER.Company_code = comp.Company_code),
  
  (SELECT COUNT(DISTINCT Employee_Code) FROM Employee EMPLYEE WHERE EMPLYEE.Company_code = comp.Company_code) FROM Company comp

ORDER BY comp.Company_code ASC;