SQLite 3.8

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create Table Insurance
(PID Int, PY float, CY float, LAT float, LON float, Location_Pair varchar(30));

Insert into Insurance (PID, PY, CY, LAT, LON, Location_Pair) values
(1, 1449866.88, 1338076.34, 30.285202, 82.105835, '(30.285202, 82.105835)'),
(2, 1849.32, 1987.47, 31.285202, 82.105835, '(31.285202, 82.105835)'),
(3, 1812.32, 295022.71, 31.285202, 82.105835, '(31.285202, 82.105835)'),
(4, 1449866.88, 369024.45, 31.285257, 82.139542, '(31.285257, 82.139542)'),
(5, 1849.32, 4657.86, 32.285257, 82.139542, '(32.285257, 82.139542)'),
(6, 200032.45, 23445.87, 32.285332, 82.132575, '(32.285332, 82.132575)');
select * from insurance


PID
PY
CY
LAT
LON
Location_Pair


1
1449866.88
1338076.34
30.285202
82.105835
(30.285202, 82.105835)

2
1849.32
1987.47
31.285202
82.105835
(31.285202, 82.105835)

3
1812.32
295022.71
31.285202
82.105835
(31.285202, 82.105835)

4
1449866.88
369024.45
31.285257
82.139542
(31.285257, 82.139542)

5
1849.32
4657.86
32.285257
82.139542
(32.285257, 82.139542)

6
200032.45
23445.87
32.285332
82.132575
(32.285332, 82.132575)


select *
from insurance i
where not exists (select 1
                  from insurance i2
                  where i2.location_pair = i.location_pair and i2.pid <> i.pid
                 )


PID
PY
CY
LAT
LON
Location_Pair


1
1449866.88
1338076.34
30.285202
82.105835
(30.285202, 82.105835)

4
1449866.88
369024.45
31.285257
82.139542
(31.285257, 82.139542)

5
1849.32
4657.86
32.285257
82.139542
(32.285257, 82.139542)

6
200032.45
23445.87
32.285332
82.132575
(32.285332, 82.132575)


select min(pid), py, sum(cy), min(location_pair)
from insurance i
where not exists (select 1
                  from insurance i2
                  where i2.location_pair = i.location_pair and i2.pid <> i.pid
                 )
group by py


min(pid)
PY
sum(cy)
min(location_pair)


5
1849.32
4657.86
(32.285257, 82.139542)

6
200032.45
23445.87
(32.285332, 82.132575)

1
1449866.88
1707100.79
(30.285202, 82.105835)

PID	PY	CY	LAT	LON	Location_Pair
1	1449866.88	1338076.34	30.285202	82.105835	(30.285202, 82.105835)
2	1849.32	1987.47	31.285202	82.105835	(31.285202, 82.105835)
3	1812.32	295022.71	31.285202	82.105835	(31.285202, 82.105835)
4	1449866.88	369024.45	31.285257	82.139542	(31.285257, 82.139542)
5	1849.32	4657.86	32.285257	82.139542	(32.285257, 82.139542)
6	200032.45	23445.87	32.285332	82.132575	(32.285332, 82.132575)