SQL problem - Project Employees I

1 min read 73 words

Problem

Query

SELECT
    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