🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.58000
  2. B.116000
  3. C.2
  4. 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 →