GATE | GATE-CS-2015 (Mock Test) | Question 13

Consider the following Employee table 
 

ID   salary   DeptName
1    10000      EC
2    40000      EC
3    30000      CS
4    40000      ME
5    50000      ME
6    60000      ME 
7    70000      CS 

How many rows are there in the result of following query? 
 

SELECT E.ID
FROM  Employee E
WHERE  EXISTS  (SELECT E2.salary
               FROM Employee E2
               WHERE E2.DeptName = \'CS\'
               AND   E.salary > E2.salary)

(A)

(B)

(C)

(D)