[LeetCode] 1075. Project Employees I (AGGREGATE)

< 문제 >

[SQL50] 1075. Project Employees I (AGGREGATE)

---

 

---

< 풀이 >

SELECT project_id, ROUND(AVG(B.experience_years)::decimal, 2) AS average_years
FROM Project A LEFT JOIN Employee B ON A.employee_id = B.employee_id
GROUP BY A.project_id;