WITH shahentbl AS(
    SELECT
        PF_CODE
        , DISTRICT_CODE
        , LATITUDE
        , LONGITUDE
        , SQRT(POWER(LATITUDE, 2) + POWER(LONGITUDE, 2)) AS shahen
    FROM
        LOCATION_TBL
    GROUP BY
        DISTRICT_CODE
)

SELECT
    d.DISTRICT_CODE AS CODE
    , d.DISTRICT_NAME AS NAME
    , s.LATITUDE AS LAT
    , s.LONGITUDE AS LON
FROM
    shahentbl as s
    INNER JOIN DISTRICT AS d
    ON s.DISTRICT_CODE = d.DISTRICT_CODE
    AND d.DISTRICT_CODE != '1101'
    CROSS JOIN LOCATION_TBL AS l
    ON l.DISTRICT_CODE = '1101'
ORDER BY
    s.shahen - SQRT(POWER(l.LATITUDE, 2) + POWER(l.LONGITUDE, 2)) DESC
    , d.DISTRICT_CODE ASC
;