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);