a) FROM (查询数据来源)

b) WHERE (根据WHERE中的条件筛选行)

c) GROUP BY (执行分组)

d) HAVING (根据HAVING中的条件在各组内进行筛选)

e) SELECT (挑出指定列)

f) ORDER BY (排序)