Here is my simple code


  • 2
    J
    select sum(TIV_2016) TIV_2016
    from insurance a
    where 1 = (select count(*) from insurance b where a.LAT=b.LAT and a.LON=b.LON) 
    and 1 < (select count(*) from insurance c where a.TIV_2015=c.TIV_2015)  ;
    

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.