The HAVING clause does which of the following ?

1. Acts EXACTLY like a WHERE clause.
2. Acts like a WHERE clause but is used for columns rather than groups.
3. Acts like a WHERE clause but is used for groups rather than rows.
4. Acts like a WHERE clause but is used for rows rather than columns.

Aggregate functions can be used in the select list or the …………… clause of a select statement. They cannot be used in a …………… clause.

1. Where, having
2. Having, where
3. Group by, having
4. Group by, where

SQL applies conditions on the groups through …………… clause after groups have been formed.

1. Group by
2. With
3. Where
4. Having

Which clause is used with "aggregate functions" ?

1. GROUP BY
2. SELECT
3. WHERE
4. Both (1) and (3)