Introduction to SQL
A subquery in an SQL SELECT statement:

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

ANSWER DOWNLOAD EXAMIANS APP