will-fong · September 23, 2021 05:13
diff --git a/.LeetCode SQL Exercises.md b/.LeetCode SQL Exercises.md
diff --git a/185. Department Top Three Salaries.sql b/185. Department Top Three Salaries.sql
 /* Write your T-SQL query statement below */
 /*
    === Steps and Assumptions ===
    1. Join employees with their departments
        1.1 Assume that employees must have a department and vice versa
    2. Find the top 3 unique salaries
        2.1 Assume that salaries can be equivalent and will both need to be output
    3. Output the department, employee, and salary
 */

 WITH empRank AS (
 SELECT
    name
    , salary
    , departmentid
    , DENSE_RANK() OVER(PARTITION BY departmentid ORDER BY salary DESC) as rank
 FROM employee
 ) 

 SELECT
    dept.name AS Department
    , empRank.name AS Employee
    , empRank.salary AS Salary
 FROM empRank
 INNER JOIN department dept
 ON empRank.departmentid = dept.id
 WHERE rank <= 3
 ;
	/* Write your T-SQL query statement below */
	/*
	=== Steps and Assumptions ===
	1. Join employees with their departments
	1.1 Assume that employees must have a department and vice versa
	2. Find the top 3 unique salaries
	2.1 Assume that salaries can be equivalent and will both need to be output
	3. Output the department, employee, and salary
	*/

	WITH empRank AS (
	SELECT
	name
	, salary
	, departmentid
	, DENSE_RANK() OVER(PARTITION BY departmentid ORDER BY salary DESC) as rank
	FROM employee
	)

	SELECT
	dept.name AS Department
	, empRank.name AS Employee
	, empRank.salary AS Salary
	FROM empRank
	INNER JOIN department dept
	ON empRank.departmentid = dept.id
	WHERE rank <= 3
	;