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
Concat(LAT,LON) in
(select concat(LAT,LON) from insurance group by LAT,LON having count(*)=1)

results matching ""

    No results matching ""