select 
    a.CODE, 
    a.NAME, 
    a.LAT, 
    a.LON 
from 
    (select 
        l.DISTRICT_CODE as CODE,
        d.DISTRICT_NAME as NAME,
        l.LATITUDE as LAT,
        l.LONGITUDE as LON,
        '1101_flg' as flg
    from 
        LOCATION_TBL as l
    inner join
        DISTRICT as d 
    on 
        l.DISTRICT_CODE = d.DISTRICT_CODE
    where 
        l.DISTRICT_CODE <> '1101'
    ) as a 
inner join 
    (select 
        l.LATITUDE as flg_LAT,
        l.LONGITUDE as flg_LON ,
        '1101_flg' as flg
    from 
        LOCATION_TBL as l 
    where 
        l.DISTRICT_CODE = '1101'
    ) as b
on 
    a.flg = b.flg
order by 
    SQRT(POWER((LAT - flg_LAT), 2) + POWER((LON - flg_LON), 2)) desc,
    CODE asc;