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 |