Variables in a select statement
To make query results more structured
To give a column in a table or a table a temporary name.
To customize the query output.