题目来源:
leetcode题目,网址:1075. 项目员工 I - 力扣(LeetCode)
解题思路:
Project 表根据 project_id 左外连接 employee表,根据 project_id 分组聚合后求平均值,保留两位小数。
解题代码:
# Write your MySQL query statement below
select project_id, cast(avg(experience_years) as decimal(10,2) ) as average_years
from Project left join Employee on Project.employee_id=Employee.employee_id
group by project_id;
总结:
保留有效数字不会,搜的。
#将数字num 保留小数点后 n 位
cast(num as deciaml(x,n)) # 该数字最多占x列
round(num ,n) # 四舍五入保留n位小数