2023/9/17 leetcode/SQL查询

题目描述：有两张表，存在外键约束，信息如下：

请写一个SQL语句，查询每一个项目中员工的平均工作年限，精确到小数点后两位。

例如：

查询结果为：

查询步骤1、先使用外键约束，查找到所有需要的信息

select project_id, experience_years from Project, Employee 
where Project.employee_id = Employee.employee

查询步骤2、分组查询需要配合聚合函数（关键字：GROUP BY、AVG）、AS是起别名

select project_id, avg(experience_years) as average_years from Project, Employee 
where Project.employee_id = Employee.employee_id group by project_id

查询步骤3、控制输出位数（ROUND(float, 2),对float四舍五入，保留两位小数）

select project_id, ROUND(avg(experience_years), 2) as average_years 
from Project, Employee where Project.employee_id = Employee.employee_id 
group by project_id