SQL查询语句执行顺序如下: (7) SELECT (8) DISTINCT <select_list> (1) FROM (3) JOIN (2) ON (4) WHERE (5) GROUP BY (6) HAVING (9) ORDER BY (10) LIMIT 前期准备工作 1、新建一个测试数