LeetCode 197: Rising Temperature
A clear explanation of the Rising Temperature SQL problem using a self join and date comparison.
10 notes
A clear explanation of the Rising Temperature SQL problem using a self join and date comparison.
A clear explanation of the Delete Duplicate Emails SQL problem using DELETE with a self join.
A SQL guide for finding users who both follow someone and have followers, then counting how many followers they have.
A SQL guide for finding the minimum distance between any two unique points on the X-axis.
A SQL guide for finding the minimum Euclidean distance between any two points in a 2D plane.
A SQL guide for finding all cinema seats that are free and adjacent to at least one other free seat.
A clear SQL guide for computing each employee's 3-month cumulative salary while excluding their most recent month.
A clear explanation of Managers with at Least 5 Direct Reports using grouping and a self join.
A clear SQL solution for finding employees whose salary is greater than their manager's salary using a self join.
A clear SQL solution for finding numbers that appear at least three times consecutively in the Logs table.