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
Maruf Ahmed🧢
Posted on
1075. Project Employees I
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)