Which statements about subqueries are true?
A subquery should retrieve only one row.
A subquery can retrieve zero or more rows.
Subqueries CANNOT be nested by more than two levels.
A subquery can be used only in SQL query statements.
A subquery CANNOT be used in an SQL query statement that uses group functions.
When a subquery is used with an inequality comparison operator in the outer SQL statement,