with double_coo_id as
( select id from public.house_coordinates,
(select count(hc.id) cnt, hc.latitude lat, hc.longitude long
 from public.house_coordinates hc
group by hc.latitude, hc.longitude
having count(hc.id) > 3) doubles_coo
 where 1=1
 and latitude = doubles_coo.lat and longitude = doubles_coo.long
)     

select eah.orponid, eah.adr_adm_ter, dci.*
from public.ent_as_house eah, double_coo_id dci
where 1=1
and livestatus = 1
and parent_id is not null
and coordinates_id = dci.id
;

CREATE TABLE #tmpCities
(Nomer INT,
City_name VARCHAR(50),
Count_people int);

INSERT INTO #tmpCities
VALUES (1, 'Москва г', 12506),
(2, 'Санкт-Петербург г', 5352),
(3, 'Новосибирск г', 1613),
(4, 'Екатеринбург г', 1469),
(5, 'Нижний Новгород г', 1259),
(6, 'Казань г', 1244);