请写一个 SQL 语句,查询每一个项目中员工的 平均 工作年限,精确到小数点后两位。
Table: Project
Table: Employee
select P.project_id,round(sum(E.experience_years)/count(*),2) average_years from Project P left join Employee E
on P.employee_id=E.employee_id
group by P.project_id
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