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:A
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;
Explanation: SELECT column_name, aggregate_function(column_name)