having | brain

Practice › LeetCode › LeetCode (archived) › LeetCode 06xx ›

LeetCode 619: Biggest Single Number

Problem Restatement We are given a table MyNumbers . Each row contains a single integer. Column Type Meaning num int A number We need to find the largest number that appears exactly once in the table. If no such number exists, return NULL . The official problem asks for the largest single occurrence number from the table. Input and Output Input table: MyNumbers Output column: num Output rules: Condition Output...

Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 596: Classes With at Least 5 Students

Problem Restatement We are given a table called Courses . Each row shows that one student is enrolled in one class. We need to return all classes that have at least five students. The result may be returned in any order. The official table has two columns: student and class . Table Courses Column Type Meaning student varchar Student name class varchar Class name The pair (student, class) is the...

Practice › LeetCode › LeetCode (archived) › LeetCode 05xx ›

LeetCode 585: Investments in 2016

Problem Restatement We are given an Insurance table. Each row represents one policyholder and includes: Their policy ID. Their total investment value in 2015. Their total investment value in 2016. Their location as latitude and longitude. We need to report the sum of tiv_2016 for policyholders who satisfy both conditions: Their tiv_2015 value is shared by at least one other policyholder. Their (lat, lon) location is unique in the table....

Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 182: Duplicate Emails

Problem Restatement We are given a table named Person . Column Type id int email varchar The id column is the primary key. Each row stores one email address. The email field is guaranteed to be non-null. We need to report all duplicate emails. A duplicate email means an email value that appears more than once in the table. The result can be returned in any order. The official statement...

#having

LeetCode 619: Biggest Single Number

LeetCode 596: Classes With at Least 5 Students

LeetCode 585: Investments in 2016

LeetCode 182: Duplicate Emails