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?

• (A) select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;
• (B) select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;
• (C) select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;
• (D) select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;