SELECT p.project_id, ROUND(AVG(e.experience_years), 2) AS average_years FROM Project p JOIN Employee e ON p.employee_id=e.employee_id GROUP BY p.project_id ORDER BY p.project_id;
Last updated 4 years ago