The correct order of the SQL Query Processing Phases is as follows:
  1. FROM
  2. ON
  3. OUTER
  4. WHERE
  5. GROUP BY
  6. CUBE/ROLLUP
  7. HAVING
  8. SELECT
  9. DISTINCT
  10. TOP
  11. ORDER BY