1075.sql (157B)
1 SELECT project_id, ROUND(AVG(experience_years), 2) AS average_years 2 FROM Project P 3 LEFT JOIN Employee E 4 ON P.employee_id = E.employee_id 5 GROUP BY project_id