🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Subqueries and Views: all 10 questions

Quiz: Subqueries and Views · Question 7 of 10

Using the company table, how many employees earn more than the average salary of department 20 (58000)?

Using the company table, how many employees earn more than the average salary of department 20 (58000)?

  1. A.2
  2. B.3
  3. C.5
  4. D.0
Answer & explanation

Correct answer: 3

Asha, Ravi and Meera earn more than 58000; Neha and Kabir earn exactly 58000.

Can you get the rest right without peeking?

Take the timed Quiz: Subqueries and Views quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →