Question

Which query correctly finds department IDs where the average salary exceeds the overall average salary across all employees?

A SELECT DeptID FROM Employee HAVING AVG(Salary) > (SELECT AVG(Salary) FROM Employee) GROUP BY DeptID
B SELECT DeptID FROM Employee WHERE AVG(Salary) > (SELECT AVG(Salary) FROM Employee) GROUP BY DeptID
C SELECT DeptID, AVG(Salary) FROM Employee HAVING AVG(Salary) > (SELECT AVG(Salary) FROM Employee)
D SELECT DeptID FROM Employee GROUP BY DeptID WHERE AVG(Salary) > (SELECT AVG(Salary) FROM Employee)
E SELECT DeptID FROM Employee GROUP BY DeptID HAVING AVG(Salary) > (SELECT AVG(Salary) FROM Employee)
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)