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.
12 notes
A SQL guide for comparing each department's monthly average salary against the company's monthly average salary.
A SQL guide for finding the minimum distance between any two unique points on the X-axis.
A SQL guide for finding all cinema seats that are free and adjacent to at least one other free seat.
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.
A clear SQL guide for computing each employee's 3-month cumulative salary while excluding their most recent month.
A clear explanation of Find Median Given Frequency of Numbers using cumulative frequency and SQL window functions.
A clear explanation of Median Employee Salary using SQL window functions to rank employees inside each company.
A clear explanation of computing cumulative games played per player and date using SQL window functions.
A clear SQL solution for finding employees whose salaries are in the top three unique salary levels within their department.
A clear SQL solution for finding every employee who earns the highest salary in their department.
A clear SQL solution for finding numbers that appear at least three times consecutively in the Logs table.
A clear SQL solution for ranking scores with dense ranking, where ties share the same rank and no rank numbers are skipped.