在SQL中的WHERE语句中添加Alias

I am trying to figure out how to add an alias to the states abbreviations. I am trying to figure out how to add an alias t