Arjun writes the following commands with respect to a table employee having fields, empno, name, department, commission. Command1 : Select count(department) from employee;
Command2: Select count(distinct department) from employee; He gets the output as 4 for the first command but gets an output 3 for the second command. Explain the output with justification.
