常用的聚合函数:count() , sum() , avg() , max() , min()
count()计数:计算表中相同人名:select count(*),name from staff group by dept,name;(查询name,需要在by后面+name)
sum()求和:计算部门工资总和:select dept,sum(salary) from staff group by dept;
avg()平均值:计算部门平均工资:select dept,avg(salary) from staff group by dept;
max()最大值&#