[SQL] leetcode | 585. Investments in 2016 예제 풀이

문제

https://leetcode.com/problems/investments-in-2016/

 

코드

select sum(tiv_2016) as tiv_2016
from insurance
where tiv_2015 in 
    (select tiv_2015
    from insurance
    group by tiv_2015
    having count(*) > 1)
    and
    (lat, lon) in
    (select lat, lon
    from insurance
    group by lat, lon
    having count(*) = 1)

-- 5분

 

문제 풀이

tiv_2015이 고유하지 않은 값은 group by tiv_2015 / having count() > 1로 구하고

lat, lon이 고유한 값은 group by lat, lon / having count() = 1로 구해줬다.

 

느낀 점

앞서 공부한 문법들을 써먹을 수 있게 돼서 뿌듯하다!