Mysql-sql查询顺序

#手写sql的顺序
select 
  distinct  <select_list>
        from   <left_table> 
            <join_type> join <right_table> 
              on <join_condition>
                  where <where_condition>
                       group by <groupby_list>
                                     having  <having_condition>
                                              order by <orderby_conditoin>
                                                           limit <limit number>；
#机读
1. FROM  <left_table>
2. ON <join_codition>
3. <join_type> JOIN <right_table>
4.WHERE <where_condition>
5. GROUP BY <group_by_list>
6. HAVING <HAVING_condition>
7. SELECT 
8. DISTINCT <select_list>
9. ORDER BY <order_by_condition>
10. LIMIT <limit_number>