README.md

1075. 项目员工 I

English Version

题目描述

None

解法

SQL

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