https://leetcode.com/problems/big-countries/description/?envType=study-plan-v2&envId=top-sql-50
Big Countries - LeetCode
Can you solve this real interview question? Big Countries - Table: World +-------------+---------+ | Column Name | Type | +-------------+---------+ | name | varchar | | continent | varchar | | area | int | | population | int | | gdp | bigint | +-----------
leetcode.com
전체 코드
SELECT name, population, area
FROM World
WHERE area >= 3000000
or population >= 25000000
'Coding Test > SQL' 카테고리의 다른 글
[프로그래머스/SQL 고득점 Kit] SELECT ALL SOLVE (1) | 2024.01.10 |
---|---|
[LeetCode] 1683. Invalid Tweets (easy, SQL) (0) | 2024.01.09 |
[LeetCode] 1148. Article Views I (easy, SQL) (1) | 2024.01.09 |
[LeetCode] 584. Find Customer Referee (easy, SQL) (0) | 2024.01.09 |
[LeetCode] 1757. Recyclable and Low Fat Products (easy, SQL) (0) | 2024.01.09 |