← Quiz: GROUP BY and HAVING: all 10 questions
Quiz: GROUP BY and HAVING · Question 6 of 10
In the company table, what does SELECT SUM(salary) FROM employees WHERE deptid = 20 return?
In the company table, what does SELECT SUM(salary) FROM employees WHERE dept_id = 20 return?
- A.58000
- B.116000
- C.2
- D.456000
Answer & explanation
Correct answer: 116000
Neha and Kabir are in department 20: 58000 + 58000.
Can you get the rest right without peeking?
Take the timed Quiz: GROUP BY and HAVING quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →