Alias in WHERE clause

Question

Accepted Answer

The logical order of SQL clause evaluation is FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY. Because WHERE runs before SELECT, the alias new_salary has not been defined yet when the database evaluates the filter. To filter on the computed value, repeat the expression: WHERE salary * 1.1 > 100000.