sum求和,vag平均数,round四舍五入
sum、avg、round
##(1)查询所有员工工资总和
select sum(sal) from emp;
##(2)查询所有员工工资总和、提成总和
select sum(sal) ,sum(comm) from emp;
##(3)查询所有员工工资总和、提成总和、薪资
select sum(sal) ,sum(comm),sum(sal + ifnull(comm,0)) money from emp;
##(3)计算员工的平均工资
select avg(sal),avg(comm) from emp;
±------------±-----------+
| avg(sal) | avg(comm) |
±------------±-----------+
| 2073.214286 | 550.000000 |
±------------±-----------+
#(4)平均工资,保留2位小数
select round(avg(sal),0),avg(comm) from emp;