sql add alias columns code example

Example 1: 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;

Example 2: sql as

SELECT CustomerID AS ID, CustomerName AS Customer