[코드카타] SQL 32 Project Employees I

Data_Student·2024년 11월 15일
0

코드카타

목록 보기
41/57

[코드카타] SQL 32 Project Employees I

32. Project Employees I
https://leetcode.com/problems/project-employees-i/

Write an SQL query that reports the average experience years of 
all the employees for each project, rounded to 2 digits.
Return the result table in any order.
select project_id, round(avg(experience_years),2) average_years
from project p join employee e on p.employee_id=e.employee_id
group by project_id

0개의 댓글