Add solution of Day-44

Shubham-Bhoite · Shubham-Bhoite · commit 91920b22fda1 · 2025-02-18T11:12:28.000+05:30
diff --git a/Solutions/Problem-44.sql b/Solutions/Problem-44.sql
@@ -25,4 +25,19 @@ Each row of this table indicates the ID of a department and its name.
  
 A company's executives are interested in seeing who earns the most money in each of the company's departments. A high earner in a department is an employee who has a salary in the top three unique salaries for that department.
 Write a solution to find the employees who are high earners in each of the departments.
-*/
+*/
+
+
+WITH RankedSalaries AS (
+    SELECT 
+        e.id,
+        e.name AS Employee,
+        e.salary AS Salary,
+        d.name AS Department,
+        DENSE_RANK() OVER (PARTITION BY e.departmentId ORDER BY e.salary DESC) AS rnk
+    FROM Employee e
+    JOIN Department d ON e.departmentId = d.id
+)
+SELECT Department, Employee, Salary
+FROM RankedSalaries
+WHERE rnk <= 3;
