Both are correct, keyword 'as' is recommended to make the renaming and makes your query more readable