聚合函数和分组查询

1.聚合函数
（1）sum：总和
（2）max：最大值
（3）min：最小值
（4）avg：平均值
（5）count：某列或记录的行数
列如：

select sum(salary) as 总和, max(salary) as 最大值,min(salary) as 最小值,
      avg(salary) as 平均值  from Employees

2.分组查询 GROUP BY(group by)子句
（1）语法：GROUP BY 字段列表 (HAVING 条件表达式)
（注意：“字段列表”表示进行分组所依据的一个或多个字段的名称；
“HAVING 条件表达式” 是一个逻辑表达式，用于指定分组后的筛选条件）
列如：

1）--计算出各个地区的平均工资
      select * from Employees
      select [Address] as 地区, avg(Salary) as 平均工资,max(Salary) as 最高工资,min(Salary) as 最低工资 
      from Employees group by [Address] 

      2)--“order by 平均工资”：平均工资从小到大排序  
      select [Address] as 地区, avg(Salary) as 平均工资,max(Salary) as 最高工资,min(Salary) as 最低工资 
      from Employees group by [Address] order by 平均工资 --avg(Salary) 

      3)--插入having子句，顺序：“group by + having + order by”；；“order by”子句一定在句子的最后
      select [Address] as 地区, avg(Salary) as 平均工资,max(Salary) as 最高工资,min(Salary) as 最低工资 
      from Employees group by [Address] having avg(Salary)>15000 order by 平均工资 --avg(Salary)

【
注意o*？：比较“group by”与“order by”
select * from Employees order by Address
select Address from Employees group by Address
】