SQL

sql as

Renames a table or column with an alias value which only exists for the
duration of the query.
Example: Aliases north_east_user_subscriptions column
SELECT north_east_user_subscriptions AS ne_subs
FROM users
WHERE ne_subs > 5;

sql as

SELECT CustomerID AS ID, CustomerName AS Customer

sql asc

Used with ORDER BY to return the data in ascending order.
Example: Apples, Bananas, Peaches, Raddish

sql as

-- AS is a keyword that allows you to rename a column or table using an alias
SELECT column_name AS 'Alias'
FROM table_name;

sql as

SELECT NAME AS "Employee Name" FROM PEOPLE;

SELECT p.NAME AS "Employee Name", s.SALARY 
FROM PEOPLE p
JOIN SALARIES s ON p.ID = s.ID;