思路1

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