How to use column alias for variables having multiple tables joined

I am trying to assign values to variables from a query having multiple tables joined, its giving error as below