# Write your MySQL query statement below
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 lat, lon
FROM Insurance
GROUP BY lat, lon
HAVING COUNT(*) <= 1
)
The key is that we need to find the question first, and then try to solve it
select round(sum(i.tiv_2016),2) as tiv_2016 from insurance i,
(select CONCAT(lat,',',lon) AS combo, count(*) as cnt from insurance group by lat,lon) loc,
(select tiv_2015, count(*) as cnt from insurance group by tiv_2015) inv
where loc.combo = CONCAT(i.lat,',',i.lon) and loc.cnt = 1
and inv.tiv_2015 = i.tiv_2015 and inv.cnt > 1;
Question