SELECT binding order

From http://msdn.microsoft.com/en-GB/library/ms189499.aspx.

SELECT statement clauses are bound in this order:

1. FROM
2. ON
3. JOIN
4. WHERE
5. GROUP BY
6. WITH CUBE/WITH ROLLUP
7. HAVING
8. SELECT
9. DISTINCT
10. ORDER BY
11. TOP