Problem: 1075. 项目员工 I

👨‍🏫 参考题解

Code

select 
    project_id,
    ROUND(AVG(e.experience_years),2) as average_years
FROM
    project as p
LEFT JOIN
    employee as e
ON
    p.employee_id = e.employee_id
GROUP BY
    p.project_id;