Assertion (A): The HAVING clause is used to filter rows after the aggregation process.
Reason (R): The WHERE clause cannot filter aggregated results, hence the HAVING clause is used after GROUP BY to apply conditions on aggregated data.
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.