반응형
https://leetcode.com/problems/big-countries/description/
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
where을 사용해본 문제였습니다.
📕 풀이방법
📔 풀이과정
정해진 조건에 해당하는 name, population, area 열을 world table에서 select해줍니다.
📕 Code
📔 SQL
select name, population, area from world
where area >= 3000000 or population >= 25000000*더 나은 내용을 위한 지적, 조언은 언제나 환영합니다.
'SQL' 카테고리의 다른 글
| (SQL) - LeetCode (easy) 627. Swap Salary (0) | 2023.05.25 |
|---|---|
| (SQL) - LeetCode (easy) 619. Biggest Single Number (0) | 2023.05.22 |
| (SQL) - LeetCode (easy) 584. Find Customer Referee (0) | 2023.05.02 |
| (SQL) - LeetCode (easy) 577. Employee Bonus (0) | 2023.04.28 |
| (SQL) - LeetCode (easy) 511. Game Play Analysis I (0) | 2023.04.12 |