3.聚合函数 3.1 MAX()最大值 3.2 GROUP BY 分组 注意语句的顺序 select --> from —> where ----> group by -----> order by 所以group by永远在 select from where 之后 order by 之前 3.3 HAVING 数据筛选 3.4 group by + with rollup 计算每一个分组的和