1Renames a table or column with an alias value which only exists for the
2duration of the query.
3Example: Aliases north_east_user_subscriptions column
4SELECT north_east_user_subscriptions AS ne_subs
5FROM users
6WHERE ne_subs > 5;
1SELECT NAME AS "Employee Name" FROM PEOPLE;
2
3SELECT p.NAME AS "Employee Name", s.SALARY
4FROM PEOPLE p
5JOIN SALARIES s ON p.ID = s.ID;
1-- AS is a keyword that allows you to rename a column or table using an alias
2SELECT column_name AS 'Alias'
3FROM table_name;