with a as (
    select  LATITUDE, LONGITUDE
    from    LOCATION_TBL
    where   DISTRICT_CODE = '1101'
)
select  l.DISTRICT_CODE as CODE,
        d.DISTRICT_NAME as NAME,
        l.LATITUDE as LAT,
        l.LONGITUDE as LON
from    LOCATION_TBL l
join    DISTRICT d
on      l.DISTRICT_CODE = d.DISTRICT_CODE
where   l.DISTRICT_CODE != '1101'
order by (LAT-(select LATITUDE from a)) * (LON-(select LONGITUDE from a)) desc,
        l.DISTRICT_CODE