What is the requirement for using a subquery in the SELECT clause?
the subquery must return at least one value.
the subquery must refer to the same table as the main query.
the subquery must return a single value.
the subquery must use an aggregate function.