with T1101 as (
    select LATITUDE as T_LAT , LONGITUDE as T_LON from LOCATION_TBL where DISTRICT_CODE = '1101'
    )
    
select 
    DISTRICT_CODE
    , ( select DISTRICT_NAME from DISTRICT where DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE ) as DISTRICT_NAME
    , LATITUDE as LAT
    , LONGITUDE as LON
 from LOCATION_TBL 
 inner join T1101 
 where DISTRICT_CODE <> '1101'
 order by POW( ABS(LATITUDE - T_LAT), 2) + POW((LONGITUDE - T_LON), 2)  desc , DISTRICT_CODE