select project_id
,cast(round(sum(experience_years)*1.0/count(project_id),2) as float) as average_years
from Project p
join Employee e
on p.employee_id = e.employee_id
group by project_id
select project_id
,cast(round(sum(experience_years)*1.0/count(project_id),2) as float) as average_years
from Project p
join Employee e
on p.employee_id = e.employee_id
group by project_id
Top comments (0)