Use of Column Aliases in the GROUP BY Clause

In Oracle, the GROUP BY Clause is evaluated first before the SELECT Clause. Column aliases do not exist yet when used in the GROUP BY Clause so a SQL Syntax error will be thrown.
 
The user would need to specify the whole column name on the GROUP BY Clause as it is impossible to use column aliases on it.
 
Other External Reference: 
Stack Overflow