Regions Financial interview question

What is wrong with this SQL statement?

Interview Answer

Anonymous

24 Mar 2016

You can't use the alias defined in the select statement in a where clause.