Small question, how to sort by query results in SQL?

流星飞舞

I have the table XXX and the field Age (int). The existing query is as follows:
select Age 'Age', Age-5 'Age 2' from XXX;

Now I want to sort by 'age 2, the following wording is incorrect:
select Age 'Age', Age-5 'Age 2' from XXX order by 'Age 2';

How do I do that?

serpent34

order by

michealhenry

select Age as [age], Age-5 as [age 2]
from XXX
order by [age 2]

xiaoru

Less as?

我是杀人狂

select * from (select Age as age, Age-5 as age 2 from XXX) a order by age 2

waxiaoning

select Age 'age', Age-5 'age 2' from XXX order by Age-5

流星飞舞

If I want to query (Age-5)> 20, how do I write it?

小小小叮当

select Age'age',Age-5'age 2'from XXX
where age-5>20
order age-5