[코드카타] SQL 18 Big Countries

Data_Student·2024년 11월 5일
0

코드카타

목록 보기
25/57

[코드카타] SQL 18 Big Countries

18. Big Countries
https://leetcode.com/problems/big-countries/

#문제 : A country is big if:
it has an area of at least three million (i.e., 3000000 km2), or
it has a population of at least twenty-five million (i.e., 25000000).
Write a solution to find the name, population, and area of the big countries.
select name, population, area
from world
where area >= 3000000 or population >= 25000000

0개의 댓글