SQL Select Subexpressions

Can often use SQL select subexpressions where SQL values, lists or tables are required. SQL select subexpressions have the following form:

    (select-expression) name