Why and when would we need to use aliases?
A real world example would be great!
Steven Parker179,853 Points
Aliases are useful in many situations, but two spring to mind immediately:
When creating a column using functions and/or concatenation:
SELECT first_name || " " || last_name AS "Full Name" -- otherwise the column header is ugly FROM sometable
And when joining tables with long names:
SELECT c.name, s.date, s.item -- this would be much longer without aliases FROM customers_listing AS c JOIN quarterly_sales_data AS s ON c.id = s.customer_id -- this would be longer too