Question

Which query correctly returns employees who earn more than the average salary of their own department?

A SELECT Name FROM Employee GROUP BY DeptID HAVING Salary > AVG(Salary)
B SELECT e.Name FROM Employee e WHERE e.Salary > (SELECT AVG(Salary) FROM Employee e2 WHERE e2.DeptID = e.DeptID)
C SELECT e.Name FROM Employee e WHERE e.Salary > (SELECT Salary FROM Employee e2 WHERE e2.DeptID = e.DeptID)
D SELECT e.Name FROM Employee e WHERE e.Salary > (SELECT AVG(Salary) FROM Employee)
E SELECT e.Name FROM Employee e, Employee e2 WHERE e.Salary > AVG(e2.Salary)
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)