1075. Project Employees I : leetcode

# Join Project table and Employee table
SELECT p.project_id, p.employee_id, e.experience_years
FROM Project p INNER JOIN Employee e
    ON p.employee_id = e.employee_id;

answer

SELECT p.project_id, ROUND(AVG(e.experience_years), 2) as average_years
FROM Project p INNER JOIN Employee e
    ON p.employee_id = e.employee_id
GROUP BY project_id;