tag

#where

2 pages tagged

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

LeetCode 595: Big Countries

Problem Restatement We are given a table called World . Each row contains information about one country. A country is considered big if at least one of these conditions is true: Its area is at least 3,000,000 . Its population is at least 25,000,000 . We need to return the name , population , and area of all big countries. The result may be returned in any order. Table World...

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

LeetCode 584: Find Customer Referee

Problem Restatement We are given a table called Customer . Each row stores a customer, their name, and the ID of the customer who referred them. We need to return the names of customers who were not referred by the customer with id = 2 . That includes two kinds of customers: Customers whose referee_id is not 2 . Customers whose referee_id is NULL , meaning they were not referred...