a) FROM (查询数据来源)
b) WHERE (根据WHERE中的条件筛选行)
c) GROUP BY (执行分组)
d) HAVING (根据HAVING中的条件在各组内进行筛选)
e) SELECT (挑出指定列)
f) ORDER BY (排序)