The SELECT clause in
the program is written incorrectly. Columns that are listed in the
clause must be separated by commas, not just blanks.
Correct answer: a
There are two statements,
the PROC SQL statement and the SELECT statement. The SELECT statement
contains three clauses: the SELECT clause, the FROM clause, and the
ORDER BY clause.
Correct answer: b
The SELECT clause lists
the columns from both tables to be queried. You must use a prefix
with the Address column because it appears in both tables. The prefix
specifies the table from which you want the column to be read.
Correct answer: b
The ORDER BY clause
specifies how the rows are to be sorted. You follow the keywords ORDER
BY by one or more column names or numbers, separated by commas.
Correct answer: c
In the FROM clause,
you list the names of the tables to be queried, separated by commas.
Correct answer: b
To create a new column
and assign a column alias to the column, you specify the following
in the SELECT clause, in the order shown here: an expression, (optional)
the keyword AS, and a column alias. The case that you use when you
create the column name is the one that will be displayed in the output.
Correct answer: a
The GROUP BY clause
is used in queries that include one or more summary functions. If
you specify a GROUP BY clause in a query that does not contain a summary
function, your clause is changed to an ORDER BY clause.
Correct answer: b
The table names that
are specified in the FROM clause must be separated by commas. Note
that you can specify columns in the WHERE clause that are not specified
in the SELECT clause.