思路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
Was this helpful?
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
Was this helpful?