Dashboard Temp Share Shortlinks Frames API

HTMLify

Day 38
Views: 2 | Author: djdj
1
2
3
4
5
6
# Write your MySQL query statement below
select distinct p.project_id, Round(AVG(e.experience_years), 2) AS average_years 
from Project AS p
join Employee AS e
on p.employee_id = e.employee_id
group by p.project_id;