고급문제풀이set1 3번 문제

해당문제 쿼리에 대해 manager 철자를 수정시 작동한다고 피드백을 주셨는데 작동이 되지 않아서 어디가 오류가 있는지 여쭤보고자 질문드립니다

SELECT C.company_code,

C.founder,

COUNT DISTINCT(L.lead_manager_code),

COUNT DISTINCT(S.senior_manager_code),

COUNT DISTINCT(M.manager_code),

COUNT DISTINCT(E.employee_code)

FROM Company C

INNER JOIN Lead Manager L ON C.company_code = L.company_code

INNER JOIN Senior Manager S ON S.company_code = L.company_code

INNER JOIN Manager M ON M.company_code = S.company_code

INNER JOIN Employee E ON E.company_code = M.company_code

GROUP BY C.Company_code, C.founder

ORDER BY C.company_code

추가로, inner join을 하는 부분이 1과 2중 어떤 부분이 왜 맞는지도 헷갈려서 설명을 부탁드리겠습니다

감사합니다

1. INNER JOIN Lead_Manager l ON c.company_code = l.company_code

   INNER JOIN Senior_Manager s ON c.company_code = s.company_code

   INNER JOIN Manager m ON c.company_code = m.company_code

   INNER JOIN Employee e ON c.company_code = e.company_code

2.  

   INNER JOIN Lead Manager L ON C.company_code = L.company_code

   INNER JOIN Senior Manager S ON S.company_code = L.company_code

   INNER JOIN Manager M ON M.company_code = S.company_code

   INNER JOIN Employee E ON E.company_code = M.company_code