Computer Science · Database Management System

Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R. Assertion A: In SQL, the WHERE clause is utilized to filter individual rows before grouping and cannot use aggregate functions, whereas the HAVING clause filters groups after grouping and permits the use of aggregate functions. Reason R: The logical execution order of SQL clauses dictates that the HAVING clause executes before the GROUP BY clause to compute data, while the WHERE clause executes after the SELECT clause to finalize row output. In the light of the above statements, choose the most appropriate answer from the options given below: