Employees above their team average

emp has (dept, salary): (eng, 100), (eng, 200), (ops, 90), (ops, 60), (hr, 80). What does this query return?

WITH d AS (
  SELECT dept, AVG(salary) AS avg_sal FROM emp GROUP BY dept
)
SELECT COUNT(*) FROM emp e
JOIN d ON e.dept = d.dept
WHERE e.salary > d.avg_sal;