# Write your MySQL query statement below
SELECT project_id, ROUND(avg(experience_years),2) AS 'average_years'
FROM Project, Employee
WHERE Project.employee_id = Employee.employee_id
GROUP BY project_id
leetcode 1075. 项目员工 I
最新推荐文章于 2024-06-15 16:09:53 发布