SQL problem - Project Employees I
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
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