📝 Question
#1331
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?
✓
Correct Answer
B. select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;
💡
Explanation
For aggregate functions group by clause is necessary.
⌨️ Press
A
B
C
D
to select