Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

Question

Admin · Accepted Answer

select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;

Admin · Answer

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;

Admin · Answer

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;

Admin · Answer

select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;

Q. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

Discusssion