The select list can include * (all columns in create table order), a list of column names in any order, character strings, column headings, and expressions including arithmetic operators. You can also include aggregate functions, which are discussed in Chapter 3, “Using Aggregates, Grouping, and Sorting.” Here are some select lists to try with the tables in the pubs2 sample database:
select
titles.*
from titles
select Name = au_fname,
Surname = au_lname
from authors
select Sales = total_sales * price,
ToAuthor = advance,
ToPublisher = (total_sales * price) -
advance
from titles
select "Social security #",
au_id
from authors
select this_year = advance,
next_year = advance
+ advance/10, third_year = advance/2,
"for book title #", title_id
from titles
select "Total income is",
Revenue = price * total_sales,
"for", Book# = title_id
from titles
