SQL/문제풀이

Project Employees I _ Easy. LeetCode

데이터분석가 이채은 2024. 10. 8. 19:42

 

Solution

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