Introduction to SQL
A subquery in an SQL SELECT statement:

cannot have its results sorted using ORDER BY.
can always be duplicated by a join.
has a distinct form that cannot be duplicated by a join.
can only be used with two tables.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The HAVING clause does which of the following?

Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.
Acts like a WHERE clause but is used for rows rather than columns.

ANSWER DOWNLOAD EXAMIANS APP