1075-project-employees-i

DevGod

Elf Vtuber

Caution

DevGod needs to write an editorial for this problem!

sql

# Write your MySQL query statement below
SELECT A.project_id,
ROUND(AVG(B.experience_years),2) AS average_years
FROM Project AS A
INNER JOIN (
    SELECT *
    FROM Employee
) AS B ON A.employee_id = B.employee_id
GROUP BY A.project_id