1. Big Countries (595)

👉https://leetcode.com/problems/big-countries/description/?envType=study-plan&id=sql-i

Big Countries - LeetCode

---

🤔 문제 분석

1) it has an area of at least three million (i.e., 3000000 km2), or

2) it has a population of at least twenty-five million (i.e., 25000000).

3) Write an SQL query to report the name, population, and area of the big countries.

 

💡 풀이

SELECT name, population, area
FROM World
WHERE area >= 3000000
OR population >= 25000000