The HAVING clause does which of the following?Acts like a WHERE clause but is used for columns rather than groups.Acts EXACTLY like a WHERE clause.Acts like a WHERE clause but is used for rows rather than columns.Acts like a WHERE clause but is used for groups rather than rows.

What is the difference between WHERE and HAVING?WHERE is always followed by HAVING.WHERE and HAVING can be used interchangeably.WHERE filters rows in source tables, HAVING filters grouped rows.HAVING filters rows in source tables, WHERE filters grouped rows.

3. What is the difference between WHERE and HAVING in SQL syntax?  A. WHERE is used to sort the result set, whereas HAVING is used to filter rows before aggregation.B. WHERE is used to filter groups after aggregation, whereas HAVING is used to filter rows before aggregation.C. WHERE is used to filter rows before aggregation, whereas HAVING is used to filter groups after aggregationD. WHERE can only be used with SELECT statements, whereas HAVING can be used with any SQL statement

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

Which of the following statements are TRUE about an SQL query?P: An SQL query can contain a HAVING clause even if it does not a GROUP BY clauseQ: An SQL query can contain a HAVING clause only if it has a GROUP BY clauseR: All attributes used in the GROUP BY clause must appear in the SELECT clauseS: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause

WHERE is used for filtering rows, HAVING is used for filtering groupsa.Falseb.True