문제
풀이
- 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
쿼리
-- leetcode, Big Countries, mysql
SELECT name, population, area
FROM World
WHERE area >= 3000000 OR population >= 25000000결과
출처 && 깃허브
