Assertion. Both WHERE and HAVING clauses are used for specifying conditions.

Reason. The WHERE condition is applicable on individual rows and HAVING condition is applicable on a group of rows.

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.

Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission :

Command1: Select count(*) from employee;
Command2: Select count(commission) from employee;

She gets the output as 4 for the first command but gets an output 3 for the second command. Explain the output with justification.

What is the default sort order of ORDER BY clause ?

Write an example query that sorts on three columns.