You can use a column's number (where the leftmost column is '1') to indicate which column to base the sort on, instead of describing the column by its name.
Pro: If you think it's likely you might change column names later, doing so won't break this code.
Con: This will generally reduce readability of the query (It's instantly clear what 'ORDER BY Reputation' means, while 'ORDER BY 14' requires some counting, probably with a finger on the screen.)
This query sorts result by the info in relative column position
3 from select statement instead of column name
SELECT DisplayName, JoinDate, Reputation FROM Users ORDER BY 3