Given below are two statements to find the sum of salaries of all employees of the English department as well as the maximum, minimum and average salary in English department. STATEMENT I ： SELECT SUM (SALARY), MAX (SALARY), MIN (SALARY), AVG (SALARY) FROM EMPLOYEE, DEPARTMENT WHERE DEPTNO=DID AND DNAME='ENGLISH'; STATEMENT II: SELECT SUM (SALARY), MAX (SALARY), MIN (SALARY), AVG (SALARY) FROM EMPLOYEE, DEPARTMENT WHERE DNAME='ENGLISH'; In the light of the above statements, choose the correct answer from the options given below

1. ABoth Statement I and Statement II are true
2. BBoth Statement I and Statement II are false
3. CStatement I is correct but Statement II is false
4. DStatement I is incorrect but Statement II is true

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: C. Statement I is correct but Statement II is false

Explanation

Statement I joins EMPLOYEE to DEPARTMENT on DEPTNO = DID and filters on English. Statement II omits the join condition, so it aggregates over a Cartesian product and counts every employee.