1Z0-071 Web TestEngine demo

Select all that apply.

• A

  You can use a column alias in the GROUP BY clause.

• B

  Using the WHERE clause after the GROUP BY clause excludes rows after creating groups.

• C

  The GROUP BY clause is mandatory if you are using an aggregating function in the SELECT clause.

• D

  Using the WHERE clause before the GROUP BY clause excludes rows before creating groups.

• E

  If the SELECT clause has an aggregating function, then columns without an aggregating function in the SELECT clause should be included in the GROUP BY clause.