单表查询

语句汇总

SELECT column, group_function(column) FROM table [ WHERE CONDITION ] 
[ GROUP BY group_by_expression ]
[ HAVING group_condition ]
[ ORDER BY column ]

执行顺序

FROM -- WHERE -- GROUP BY -- SELECT -- HAVING -- ORDER BY