___________ functions in SQL, which produce a single value for an entire group of table entries.
Aggregate functions
SQL
NULL
None of these
Which of the following is an operator defines a range of values in which the values of the field falls makes the predicate true?
IN
NOT IN
BETWEEN
________ clause allows you to define a subset of values in a particular field in terms of another field.
GROUP BY
WHERE
ORDER BY
none of these