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.
Return the result table in any order.
문제링크
조건정리
1. 면적 3,000,000 이상 / 인구 25,000,000 이상인 나라 필터링
2. 이름, 인구수, 면적 출력
풀이
SELECT name, population, area
FROM world
WHERE area >= 3000000 OR population >= 25000000