DEV Community

Maruf Ahmed🧢
Maruf Ahmed🧢

Posted on

1075. Project Employees I

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)