Consider the following EMP table and answer the question below.
|
EMP_NO |
SALARY |
GRADE |
|
E001 |
1000 |
E1 |
|
E002 |
2000 |
E4 |
|
E003 |
1500 |
E2 |
|
E004 |
4000 |
E4 |
Which of the following select statement should be executed if we need to display the average salary of employees who belong to grade "E4"?
1
select avg(salary) from EMP whose grade="E",
2
select avg(salary) from EMP having grade="E4";
3
select avg(salary) EMP group by grade where grade="E4";
4
select avg(salary) from EMP group by grade having grade="E4";