See why you should always use alias or column names in your ORDER BY clauses, rather than ordinal position.

A little background on how I went from an economics major to a DBA.