Blog · Guide
SQL AS Explained: Rename Columns in the Result
AS gives a column a clearer name in the output — product_name instead of name, list_price instead of price.
Rename for readability
SELECT name AS product_name, price AS list_price FROM products;
The table still stores name and price. Only the result headers change. Handy when you calculate qty * price AS line_total.
Try it yourself
The fastest way to lock this in is a short drill on the same Northstar Market tables.