Question

Consider: SELECT DEPT, AVG(SALAR

  • Y FROM EMP GROUP BY DEPT HAVING AVG(SALAR
  • Y > 50000; If EMP has: IT(60k,45k,70k), HR(55k,40k), Finance(80k) — which output is correct?
A IT: 58333, HR: 47500, Finance: 80000
B IT: 58333, Finance: 80000
C HR: 47500
D IT: 58333, HR: 47500
E Finance: 80000, IT: 58333
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)