Assertion (A): To find the total sales per region from a sales database, the GROUP BY clause is used in the SQL query.
Reason (R): The GROUP BY clause summarizes or aggregates identical data into single rows by specific columns.
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