순간을 기록으로

[LeetCode] Big Countries | MySQL 본문

Problem Solving

[LeetCode] Big Countries | MySQL

luminous13 2022. 4. 8. 12:34

문제

- name, population, and area of the big countires --> select name, population, area

- area은 적어도 3백만km^2이다. --> area > 3000000

-또는 --> or

- population은 적어도 2천5백만이다. --> population > 25000000

풀이

select name, population, area
from world
where area >= 3000000 or population >= 25000000;

출처: https://leetcode.com/problems/big-countries/

 

Big Countries - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

 

Comments