image.png
    image.png

    这个题的重点就是怎么将两个列的值进行合并

    1. select sum(TIV_2016) TIV_2016  from insurance where TIV_2015 in ( select TIV_2015 from insurance group by TIV_2015 having count(TIV_2015) > 1) and
    2. concat(lat,lon) in (select concat(lat,lon) from insurance group by concat(lat,lon) having count(*)=1)