[LeetCode] 1075. Project Employees I

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH Project_employee AS (
    SELECT p.*
        , e.experience_years
    FROM Project AS p
        LEFT JOIN Employee AS e ON p.employee_id = e.employee_id
)

SELECT project_id
     , ROUND(AVG(experience_years), 2) AS average_years
FROM Project_employee
GROUP BY project_id