>This is because your aliases. To fix it, use

Order by x

>
>
This not fix it, this is a workaround only.

But, on next code it is out of game:

CREATE TABLE #saleshist (sales INT)

INSERT INTO #saleshist VALUES (10)
INSERT INTO #saleshist VALUES (1)

-- Bug Next order column 1, now found a way for set the result order with  #saleshist.sales
SELECT sales%10 as sales FROM #saleshist ORDER BY #saleshist.sales

DROP TABLE #saleshist