Assertion (A): A query using the GROUP BY clause can also use the WHERE clause to filter rows before they are grouped.
Reason (R): The WHERE clause is processed before the GROUP BY clause in the SQL query execution order, allowing for pre-group filtering of rows.
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.