In the examples shown so far, the column names of the base table were used for the column names of the result table.
It is possible to give result columns new names.
SELECT title mrmrs, firstname christianname
name surname, city address
FROM customer
WHERE city = 'New York'
Of course, these two forms of renaming result sets and result columns can be combined in a statement.
SELECT report2 (name customer, city dispatch, account)
FROM customer
WHERE account = 0.0
FOR REUSE
