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

Accepted Answer

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

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?

Make the most of this question