sql书写顺序: 1. select 2. from 3. join 4. on 5. where 6. group by 7. having 8. union 9. order by 10. limit 执行顺序: 1. from 2. join 3. on 4. where 5. group by 6. having 7. select 8. distinct 9. order by 10. limit