sub query can retrieve zero or more rows, sub query is used with an inequality comparison operator in the outer SQL statement, and the column list in the SELECT clause of the sub query should contain only one column.
Incorrect answer:
A: sub query can retrieve zero or more rows
C: sub query is not SQL query statement
D: sub query can be nested
E: group function can be use with sub query