select * 
  from (
         select ph.orponid as GlobalID
              , sys.external_id as "HouseID"
              , ph.adr_adm_ter as "Адрес"
              , count() over(partition by sys.external_id) as x_cnt
           from edw_prod.edw_ods.t_000148_ent_as_house ph 
           JOIN edw_prod.edw_ods.t_000148_ent_id_vs_o_add sys
             on ph.id = sys.house_id and sys.system_id = 354541532
          where 1=1
            and ph.livestatus = 1
            and ph.mrf_id = 354858663--Сибирь
            and ph.parent_id is not null
       ) v
 where x_cnt > 1
 order by GlobalID;

, count(*) over(partition by hc.latitude, hc.longitude) as x_cnt