he SELECT statement pattern for membership exceptions uses1 pointthe COUNT function in a condition in a nested query in the WHERE clause.the COUNT function in a condition with a nested query in the HAVING clause.the SUM function in a condition with a nested query in the HAVING clause.the NOT IN operator in the WHERE clause in a condition with a Type I nested query

.Question 20Indicate when a SELECT statement for a containment exception should use the DISTINCT keyword inside the COUNT function in the HAVING condition.1 pointthe COUNT function applies to a unique column of the outer query.the COUNT function applies to a non unique column of the outer querythe COUNT function applies to the entire row of the nested query.the COUNT function applies to the entire row of an outer query.

Clarify the role of the HAVING clause highlighting its distinctions from the WHEREclause in SQL.

What is the purpose of the SQL HAVING clause?

Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.Where, havingHaving, whereGroup by, havingGroup by, where

Which of the following statements is wrong?Question 7Select one:a.Aggregate functions are mostly used in the WHERE clause of a SELECT statement.b.When using the equivalence operator (=) in the predicate, you must make sure that the subquery retrieves exactly one value.c.SQL's concept of joining two or more tables also applies to joining two copies of the same table.d.Output of the COUNT() function is the number of rows or column values that would be selected by the query.