Using column aliases in a WHERE clause

https://www.labcorner.de/using-column-aliases-in-a-where-clause/