Assertion. The ORDER BY clause of SELECT statement is carried out in the last after executing other clauses of the SELECT statement.

Reason. The ORDER BY clause is carried out on the final result of the SELECT query.

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.

Assertion. MOD() and MIN() are numeric functions, yet they are different types of functions.

Reason. MOD() is a single-row function and MIN() is a group function.

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.

Assertion. The GROUP BY clause yields summary results using group functions.

Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.

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.

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.