LeetCode 619: Biggest Single Number
A SQL guide for finding the largest number that appears exactly once in a table.
13 notes
A SQL guide for finding the largest number that appears exactly once in a table.
A clear explanation of finding the first device used by each player using SQL aggregation and a join.
A clear explanation of finding each player's first login date using SQL aggregation.
A clear SQL guide for computing the overall friend request acceptance rate with duplicate pairs counted once.
A clear SQL guide for finding classes that have at least five students.
A clear SQL guide for finding the customer who placed the most orders.
A clear SQL guide for summing 2016 investments for policies with repeated 2015 investment values and unique locations.
A clear SQL guide for counting students in every department, including departments with zero students.
A clear SQL guide for computing each employee's 3-month cumulative salary while excluding their most recent month.
A clear SQL guide for finding the question with the highest answer rate from survey logs.
A clear explanation of calculating the fraction of players who logged in again the day after their first login.
A clear explanation of computing cumulative games played per player and date using SQL window functions.
A clear explanation of the Trips and Users SQL problem using joins, filtering, grouping, and conditional aggregation.