The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id.

|----|-------|--------|--------------|

The Department table holds all departments of the company.

|----|----------|

Write a SQL query to find employees who earn the top three salaries in each of the department. For the above tables, your SQL query should return the following rows.

|------------|----------|--------|

SELECT d.Name as Department, e.Name as Employee, e.Salary
FROM Employee e, Department d
WHERE e.DepartmentId = d.Id
AND (SELECT COUNT(DISTINCT e.Salary) as c
         FROM Employee
        WHERE DepartmentId = d.Id
        Salary > e.Salary
         ) < 3