LeetCode 615: Average Salary: Departments VS Company
A SQL guide for comparing each department's monthly average salary against the company's monthly average salary.
Tag
Window-Function
12 notes
LeetCode 613: Shortest Distance in a Line
A SQL guide for finding the minimum distance between any two unique points on the X-axis.
LeetCode 603: Consecutive Available Seats
A SQL guide for finding all cinema seats that are free and adjacent to at least one other free seat.
LeetCode 601: Human Traffic of Stadium
A SQL guide for finding stadium records that belong to runs of at least three consecutive ids where each row has at least 100 people.
LeetCode 579: Find Cumulative Salary of an Employee
A clear SQL guide for computing each employee's 3-month cumulative salary while excluding their most recent month.
LeetCode 571: Find Median Given Frequency of Numbers
A clear explanation of Find Median Given Frequency of Numbers using cumulative frequency and SQL window functions.
LeetCode 569: Median Employee Salary
A clear explanation of Median Employee Salary using SQL window functions to rank employees inside each company.
LeetCode 534: Game Play Analysis III
A clear explanation of computing cumulative games played per player and date using SQL window functions.
LeetCode 185: Department Top Three Salaries
A clear SQL solution for finding employees whose salaries are in the top three unique salary levels within their department.
LeetCode 184: Department Highest Salary
A clear SQL solution for finding every employee who earns the highest salary in their department.
LeetCode 180: Consecutive Numbers
A clear SQL solution for finding numbers that appear at least three times consecutively in the Logs table.
LeetCode 178: Rank Scores
A clear SQL solution for ranking scores with dense ranking, where ties share the same rank and no rank numbers are skipped.