WITH base AS (
    SELECT
        LATITUDE la,
        LONGITUDE lo
    FROM
        LOCATION_TBL
    WHERE
        DISTRICT_CODE = '1101'
),
dist AS(
    SELECT
        sqrt(
            pow(l.LATITUDE - base.la, 2) + pow(l.LONGITUDE - base.lo, 2)
        ) d,
        DISTRICT_CODE,
        LATITUDE,
        LONGITUDE
    FROM
        base,
        LOCATION_TBL l
    WHERE
        DISTRICT_CODE != '1101'
)
SELECT
    dist.DISTRICT_CODE AS CODE,
    DISTRICT_NAME AS NAME,
    LATITUDE AS LAT,
    LONGITUDE AS LON
FROM
    dist
    INNER JOIN DISTRICT d ON dist.DISTRICT_CODE = d.DISTRICT_CODE
ORDER BY
    dist.d DESC,
    dist.DISTRICT_CODE