with tmp as (
    select
    DISTRICT_CODE,
    cast(LATITUDE * 100000000 as integer) as LATITUDE,
    cast(LONGITUDE * 100000000 as integer) as LONGITUDE
    --round(LATITUDE, 6) as LATITUDE,
    --round(LONGITUDE, 6) as LONGITUDE
    --LATITUDE,
    --LONGITUDE
    from LOCATION_TBL
),
tbl as (
    select DISTRICT_CODE,
    (select LATITUDE from tmp where DISTRICT_CODE = '1101') - LATITUDE as X,
    (select LONGITUDE  from tmp where DISTRICT_CODE = '1101') - LONGITUDE as Y
    from tmp
)

select
DISTRICT_CODE as CODE,
DISTRICT_NAME as NAME,
LATITUDE as LAT,
LONGITUDE as LON
from LOCATION_TBL
left join tbl using(DISTRICT_CODE)
left join DISTRICT using(DISTRICT_CODE)
where DISTRICT_CODE != '1101'
order by
X * X + Y * Y desc, DISTRICT_CODE