Sorting SQL statement result data by column alias is not possible.

Keep practicing — related questions

• Order by clause cannot have aliases of columns....
• Column ALIASE can be used in Order by clause ?
• You can use a column alias in order by clause
• The default sorting order of SQL statement is ASC....
• Order by – clause comes last in select statement
• Can the ORDER BY clause use column index of the select clause to sort the fetched records.
• ALIAS can be used for TABLE as well as COLUMN to simplify interpretation of SQL query
• Can proc sort do everything a normal SQL can do?