Think I got it now after seeing it taught at PASS last week. The order in which a Select statement is deconstructed:

from

on/join

where

group by

having

select

distinct/order by/top

Which is why we can only refer to the alias in the order by clause. One of those light bulb comes on moments for me 🙂