department-top-three-salaries.sql

/*
 * @link       https://leetcode.com/problems/department-top-three-salaries/
 * @difficulty HARD
 */
SELECT d.name   AS Department,
       e.name   AS Employee,
       e.salary AS Salary
FROM Employee e
         JOIN
     Department d ON e.departmentId = d.id
WHERE (SELECT COUNT(DISTINCT salary)
       FROM Employee e2
       WHERE e2.departmentId = e.departmentId
         AND e2.salary >= e.salary) <= 3
ORDER BY Department, Salary DESC;