from (left table)—> join (right table)—> on —> where —> group by —> 聚合函数 —> having —-> select —-> distinct —-> union —-> order by —> limit
from -> join on -> where -> group by -> select - > having -> order by -> limit
