Column aliases in ORDER BY works on older SQL version but not on SQL 2014?

The rule of thumb is: don’t prefix the column aliases with a table name or table alias in the ORDER BY clause, OR just use the column name directly instead.  This MSDN article explains it in detail.