sql server alias "invalid column name" code example

Example: invalid column name sql

Whenever this happens to me, I press Ctrl+Shift+R which refreshes intellisense, close the query window (save if necessary), then start a new session which usually works quite well.