Question

Which query returns departments whose average salary is greater than 60000?

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