1. Having和Where的区别:先执行Where的条件,再执行Having的条件

  2. group by和order by的区别:group by是分组,order by是排序

  3. select子句的顺序:select...from...where...group by...having...order by...limit...