leetcode - 1075. Project Employees I

난이도 : Easy

 

 

SELECT project_id
     , ROUND(AVG(experience_years), 2) average_years
FROM Project
     LEFT JOIN Employee ON Project.employee_id = Employee.employee_id
GROUP BY project_id

Accepted