力扣SQL50 项目员工 I ROUND AVG

Problem: 1075. 项目员工 I

👨‍🏫 参考题解

Code

select project_id,ROUND(AVG(e.experience_years),2) as average_years
FROMproject as p
LEFT JOINemployee as e
ONp.employee_id = e.employee_id
GROUP BYp.project_id;