What’s the purpose of SQL keyword “AS”?

There is no difference between both statements above. AS is just a more explicit way of mentioning the alias