WITH SUB AS(
    SELECT
        DISTRICT_CODE,
        LATITUDE,
        LONGITUDE,
        SQRT(
            POW((SELECT LATITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE='1101') - LATITUDE, 2)
            +POW((SELECT LONGITUDE FROM LOCATION_TBL WHERE DISTRICT_CODE='1101') - LONGITUDE, 2)
            ) AS R
    FROM
        LOCATION_TBL
    WHERE
        DISTRICT_CODE<>'1101'
    )
    
SELECT
    SUB.DISTRICT_CODE AS CODE,
    DISTRICT_NAME AS NAME,
    LATITUDE AS LAT,
    LONGITUDE AS LON
FROM
    SUB
    INNER JOIN DISTRICT AS D
        ON D.DISTRICT_CODE=SUB.DISTRICT_CODE
ORDER BY
    SUB.R DESC,
    SUB.DISTRICT_CODE ASC
;