Computer Science · SQL Queries
Consider the following EMP table: EMP_NO | SALARY | GRADE E001 | 1000 | E1 E002 | 2000 | E4 E003 | 1500 | E2 E004 | 4000 | E4 Which of the following SQL SELECT statements should be executed to display the average salary of employees who belong to grade 'E4'?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1SELECT AVG(SALARY) FROM EMP GROUP BY GRADE HAVING GRADE = 'E4';✓
- 2SELECT AVG(SALARY) FROM EMP GROUP BY GRADE WHERE GRADE = 'E4';
- 3SELECT AVG(SALARY) FROM EMP HAVING GRADE = 'E4';
- 4SELECT AVG(SALARY) FROM EMP WHERE GRADE = 'E4';
Correct answer
SELECT AVG(SALARY) FROM EMP GROUP BY GRADE HAVING GRADE = 'E4';
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice SQL Queries MCQs →Want more practice questions on SQL Queries?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · SQL Queries