CREATE TABLE #saleshist (sales INT)

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

-- Next order column 1
SELECT #saleshist.sales as x,sales%10 as sales FROM #saleshist ORDER BY #saleshist.sales

-- BUG: Next order column 2, expected 1
SELECT sales as x ,sales%10 as sales FROM #saleshist ORDER BY #saleshist.sales

DROP TABLE #saleshist