Orden de ejecución de instrucciones SQL:

1. FROM

2. ON

3. JOIN

4. WHERE

5. GROUP BY

6. WITH CUBE OR WITH ROLLUP

7. HAVING 

8. SELECT 

9. DISTINCT

10. ORDER BY 

11. TOP