문제
![](https://velog.velcdn.com/images%2Fcosmos%2Fpost%2F057aae0c-9ee2-48cf-a661-897f49945dba%2F%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA%202021-09-23%20%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE%205.32.03.png)
풀이
- a country is big if it has an area of bigger than 3 million square km or a population of more than 25 million.
- write a sql solution to output big countries name, popluation and area.
- for example, according to the above table, we should output
쿼리
SELECT name, population, area
FROM World
WHERE area >= 3000000 OR population >= 25000000
결과
![](https://velog.velcdn.com/images%2Fcosmos%2Fpost%2F3cc59be3-1191-4fb7-82d6-b846c25a5243%2F%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA%202021-09-23%20%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE%205.41.18.png)
![](https://velog.velcdn.com/images%2Fcosmos%2Fpost%2Fb3604c67-4d27-4cd3-be72-9893f35a3732%2F%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA%202021-09-23%20%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE%205.41.27.png)
출처 && 깃허브
leetcode
github