with h1101 as(
    SELECT
        LATITUDE as la,LONGITUDE as lo
    FROM
        LOCATION_TBL
    WHERE
       DISTRICT_CODE = '1101'
)

SELECT
    t2.DISTRICT_CODE as CODE
    ,DISTRICT_NAME as NAME
    ,LATITUDE as LAT
    ,LONGITUDE as LON
from
    h1101 t1
cross join LOCATION_TBL t2
inner join DISTRICT t3 on t2.DISTRICT_CODE = t3.DISTRICT_CODE
where
    t2.DISTRICT_CODE <> '1101'
order by
        abs(LATITUDE - la) + abs(LONGITUDE - lo) DESC
        ,t2.DISTRICT_CODE ASC