[LeetCode/SQL] 1075. Project Employees I

[LeetCode/SQL]

---

📌 1075. Project Employees I

문제

풀이

- 각 프로젝트 별 모든 직원의 근속년수의 평균을 출력
- 소수점 2까지 표현하기 

방법

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