Project Employees I.md

⚙문제보기

🔎문제 풀이 MySQL

SELECT project_id, ROUND(AVG(experience_years), 2) AS 'average_years'
FROM Project P JOIN Employee E ON P.employee_id = E.employee_id
GROUP BY project_id;