[LeetCode] 585. Investments in 2016

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT ROUND(SUM(tiv_2016), 2) 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 DISTINCT lat, lon
                    FROM Insurance
                    GROUP BY lat, lon
                    HAVING COUNT(*) = 1)