HOW MANY ROWS OF DATA ARE RETURNED AFTER EXECUTING THE FOLLOWING ST...

9. How many rows of data are returned after executing the following statement?SELECT DEPT_ID, SUM(NVL(SALARY,100)) FROM EMPGROUP BY DEPT_ID HAVING SUM(SALARY) > 400;Assume the EMP table has ten rows and each contains a SALARY value of 100, except for one, which has a null value in the SALARY field. The first five rows have a DEPT_ID value of 10 while the second group of five rows, which includes the row with a null SALARY value, has a DEPT_ID value of 20. (Choose the best answer.) A. Two rows B. One row C. Zero rows D. None of the above