sql asc

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

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;

1SELECT CustomerID AS ID, CustomerName AS Customer

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;