LeetCode 197: Rising Temperature
A clear explanation of the Rising Temperature SQL problem using a self join and date comparison.
Tag
Self-Join
10 notes
LeetCode 196: Delete Duplicate Emails
A clear explanation of the Delete Duplicate Emails SQL problem using DELETE with a self join.
LeetCode 614: Second Degree Follower
A SQL guide for finding users who both follow someone and have followers, then counting how many followers they have.
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 612: Shortest Distance in a Plane
A SQL guide for finding the minimum Euclidean distance between any two points in a 2D plane.
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 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 570: Managers with at Least 5 Direct Reports
A clear explanation of Managers with at Least 5 Direct Reports using grouping and a self join.
LeetCode 181: Employees Earning More Than Their Managers
A clear SQL solution for finding employees whose salary is greater than their manager's salary using a self join.
LeetCode 180: Consecutive Numbers
A clear SQL solution for finding numbers that appear at least three times consecutively in the Logs table.