1075. Project Employees I

• 문제
  
• 정답

SELECT project_id, round((sum(experience_years)/count(E.employee_id)),2) average_years 
FROM Project P LEFT JOIN Employee E ON P.employee_id = E.employee_id 
GROUP BY 1  

• 결과