SELECT 2

The clause _________________ indicates the tables you want to query and table operators like joins if applicable

• FROM

• SELECT

• WHERE

• GROUP BY

The clause _________________ filters rows based on a predicate. Only rows for which the predicate evaluates to true are returned. Rows for which the predicate evaluates to false or an unknown state are not returned.

• FROM

• SELECT

• WHERE

• GROUP BY

The clause _________________ defines a group for each distinct combination of values from the input tables columns in the grouping list.

• FROM

• SELECT

• WHERE

• GROUP BY

This phase is responsible for filtering data based on a predicate, but it is evaluated after the data has been grouped.

• HAVING

• ORDER BY

• WHERE

• GROUP BY

This phase is responsible for ordering data based on ascending or descending order.

• HAVING

• ORDER BY

• WHERE

• GROUP BY

What are the 2 query clauses that enable you to filter data based on predicates?

• SELECT

• GROUP BY

• ORDER BY

• WHERE

• HAVING

Which 'aggregate function' statement will return the numerical sum of all values in one column or more?

• COUNT(column_name)

• SUM(column_name)

• DISTINCT(column_name)

• AVG(column_name)

Which 'aggregate function' statement will return the total number of rows in a table, except for those with a null value?

• COUNT(column_name)

• SUM(column_name)

• DISTINCT(column_name)

• COUNT(*)

Which 'aggregate function' statement will return the numerical average of all values in one column or more?

• COUNT(column_name)

• SUM(column_name)

• DISTINCT(column_name)

• AVG(column_name)

When using the 'count(*)' function statement, rows with 'null' values will be returned as well.

• TRUE

• FALSE