Question $1(1$ point$)$

When the GROUP BY clause is used without aggregate functions it will give you the same result as what keyword?

Question $1$ options:

HAVING

DISTINCT

WHERE

FROM

Question $2(1$ point$)$

Which clause is used to group matching values of a specified column together?

Question $2$ options:

WHERE

FROM

GROUP BY

SELECT

Question $3(1$ point$)$

When does the HAVING clause act on rows?

Question $3$ options:

After the rows have been grouped

During the grouping of rows

Before the rows are grouped

Question $4(1$ point$)$

If you want to include a column in the output that is not a result of an aggregate calculation you must add it to what clause?

Question $4$ options:

WHERE

HAVING

FROM

GROUP BY

Question $5(1$ point$)$

Filters that use a predicate on an aggregate function must be placed in what clause?

Question $5$ options:

HAVING

FROM

WHERE

GROUP BY

Question $6(1$ point$)$

Grouping data with aggregate functions enables you to see $\_\_\_\_\_\_\_\_\_\_\_\_$ for categories of data.

Question $6$ options:

subtotal

individual values

grand total

Question $7(1$ point$)$

When you want to group only a subset of rows you should eliminate rows first in what clause?

Question $7$ options:

HAVING

WHERE

SELECT

FROM

Question $8(1$ point$)$

Columns referenced in the WHERE clause must be a part of what?

Question $8$ options:

The columns referenced in the ORDER BY clause.

The columns used in aggregate functions.

Tables defined in the FROM clause.

The columns referenced in the SELECT clause.

Question $9(1$ point$)$

Which two clauses are used to filter the result set?

Question $9$ options:

SELECT and FROM

WHERE and HAVING

GROUP BY and HAVING

FROM and WHERE

Question $10(1$ point$)$

The WHERE and HAVING clauses use a $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ to determine whether a row will be included in the final result set.

Question $10$ options:

correlation name

value expression

column expression

search condition