If column names are aliased in the SELECT list, only the alias name can be used in the ORDER BY clause.

• 如果列名已在SELECT列表中有了别名,则ORDER BY子句中只能使用别名。