Assertion. Both WHERE and HAVING clauses work with GROUP BY in a SELECT statement.

Reason. The WHERE clause is applied before forming groups of rows and HAVING clause is applied after forming the groups.

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.

Both A and R are true and R is the correct explanation of A.

Explanation
Both the WHERE and HAVING clauses can be used with the GROUP BY clause in a SELECT statement to filter and specify conditions for rows and groups, respectively. The WHERE clause filters rows before they are grouped, while the HAVING clause filters groups of rows after they have been grouped by the GROUP BY clause. This is because WHERE conditions cannot include aggregate functions, whereas HAVING conditions can include them.