The column alias should be put in uppercase and enclosed within double quotation marks in the WHERE