Why are you not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause?
You not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause, because the WHERE clause is logically evaluate...
https://www.interviewquestionspdf.com/2016/12/why-are-you-not-allowed-to-refer-to.html
You not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause, because the WHERE clause is logically evaluated in a phase earlier to the one that evaluates the SELECT clause.
This is the reason that below statement will not work:
