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