LeetCode 619: Biggest Single Number
A SQL guide for finding the largest number that appears exactly once in a table.
Tag
Having
4 notes
LeetCode 596: Classes With at Least 5 Students
A clear SQL guide for finding classes that have at least five students.
LeetCode 585: Investments in 2016
A clear SQL guide for summing 2016 investments for policies with repeated 2015 investment values and unique locations.
LeetCode 182: Duplicate Emails
A clear SQL solution for reporting email values that appear more than once in the Person table.