SQL Practice Logo

SQLPractice Online

Level 3 - IntermediateOutput Prediction Questions

Output: Above Department Average Count

What count is returned by this query? SELECT COUNT(*) FROM employees e WHERE e.salary > (SELECT AVG(e2.salary) FROM employees e2 WHERE e2.department_id = e.department_id);