← 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)?
- A.2
- B.3
- C.5
- 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 →