By VE
с
Identify the average salary of the jobs 'MANAGER' and 'ANALYST'. Display job, average salary if the identified average salary is more
than 1500. write a sql
Answers
Answered by
1
Explanation:
khcckhxkgcyoxixhzigcig☠️☠️☠️☠️☠️☠️u jcugculcutxitfuxyhjgfigq Jun ufxtuxuzuxhfzfyx
Answered by
0
Answer: select JOB, avg(Sal)"Average Salary" FROM Emp WHERE JOB='ANALYST' OR JOB='MANAGER' GROUP BY JOB
HAVING avg(Sal)>1500;
Explanation:
Similar questions