[LeetCode] 문제 풀이

595. Big Countries

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

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

620. Not Boring Movies

https://leetcode.com/problems/not-boring-movies/

select id, movie, description, rating
from cinema
where mod(id,2) = 1
and description <> 'boring'
order by rating desc

182. Duplicate Emails

https://leetcode.com/problems/duplicate-emails/

select email as Email
from person
group by email
having count(*) > 1


select email
from person
group by email
having count(id) >= 2

175. Combine Two Tables

https://leetcode.com/problems/combine-two-tables/

select p.firstName, p.lastName , a.city, a.state
from person p left outer join address a on p.personId = a.personId