Given a correlated subquery in the SELECT list, what does this query return for each employee?
SELECT e.name,
(SELECT COUNT(*) FROM employees e2
WHERE e2.dept_id = e.dept_id
AND e2.salary > e.salary) + 1 AS dept_salary_rank
FROM employees e;