[LeetCode/Easy] 1075. Project Employees I

1. Input

1) Table: Project (pk = (project_id, employee_id))

2) Table: Employee (pk = employee_id)

 

2. Output

1) 각 프로젝트별로 참여하는 모든 직원들의 평균 경력을 소수점 2자리까지 출력하기

- 순서는 상관 없다.

 

3. Example

 

4. Code

1) 첫 코드(2023/04/04)

select project_id, round(avg(experience_years),2) as average_years
from Project p, Employee e
where p.employee_id=e.employee_id
group by project_id;