1. Use GROUPING to return data that is represented, for example, from an aggregate function.

Group of answer choices

True

False

2. SELECT Name, MAX(Pay) From SalesTeam

Valid statement?

Group of answer choices

True

False

3. Individual columns included in a field list must be included in the GROUP BY clause as well.

Group of answer choices

True

False

4. HAVINGs are similar to WHEREs although HAVINGs assess groups totals and WHEREs individual records.

Group of answer choices

True

False

5. SELECT type, description, AVG(price) Avg, SUM(price) Sum FROM titles GROUP BY type

Group of answer choices

Is not a valid statement

Is a valid statement

6. You can only have a single Aggregate Function in a GROUP BY statement

Group of answer choices

True

False

7. Correct order of clauses in a SELECT statement?

SELECT FROM WHERE GROUP BY ORDER BY HAVING

Group of answer choices

True

False

8. SELECT SUM(sales) Sum FROM orders WHERE SUM(Sales) > 10000

Group of answer choices

True

False

9. A HAVING statement requires a GROUP BY statement.

Group of answer choices

True

False