I am trying to run a query on BigQuery, but I keep getting this error message; "Syntax error: Expected end of input but got keyword AS"
Attached below is the screenshot of the query and the error code on BigQuery. Please any help on how to resolve this would be appreciated.