Assertion (A): The HAVING clause can perform filtering on columns that are not included in the GROUP BY clause.
Reason (R): The HAVING clause applies conditions on the results after grouping and aggregation, and it evaluates conditions on aggregated data, which might not necessarily include all columns used in the GROUP BY clause.
Choose the correct option:
1
Both A and R are true, and R is the correct explanation of A.
2
Both A and R are true, but R is not the correct explanation of A.
3
A is true, but R is false.
4
A is false, but R is true.