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

TuteeHUB · Accepted Answer

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

TuteeHUB · Answer

select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;

TuteeHUB · Answer

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

TuteeHUB · Answer

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

1.	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;
Answer» C. select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;

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?

Discussion

No Comment Found

Related MCQs

Reply to Comment