A table expression is
a SELECT statement. It is the fundamental building block of most SQL
procedure statements. You can combine the results of multiple table
expressions with set operators, which creates a query expression.
Use one ORDER BY clause for an entire query expression. Place a semicolon
only at the end of the entire query expression. A query expression
is often only one SELECT statement or table expression.