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