search

congr / world

2 stars 1 forks source link

LeetCode : 595. Big Countries #436

Closed congr closed 5 years ago

congr commented 5 years ago

https://leetcode.com/problems/big-countries/ image image

congr commented 5 years ago 
# Write your MySQL query statement below
select name, population, area from World
where area > 3000000 or population > 25000000
congr commented 5 years ago 
# Write your MySQL query statement below
select name, population, area from World
where area > 3000000

UNION

select name, population, area from World
where population > 25000000