WITH TMP1 AS(
SELECT
    D.DISTRICT_CODE AS CODE,
    D.DISTRICT_NAME AS NAME,
    L.LATITUDE AS LAT,
    L.LONGITUDE AS LON,
    SQRT(POWER(ABS(L.LATITUDE - 43.044502),2) + POWER(ABS(L.LONGITUDE - 141.354139),2)) AS DISTANCE
FROM
    DISTRICT AS D
INNER JOIN
    LOCATION_TBL AS L
ON
    D.DISTRICT_CODE = L.DISTRICT_CODE
)

SELECT
    CODE,
    NAME,
    LAT,
    LON
FROM
    TMP1
WHERE
    CODE != 1101
ORDER BY
    DISTANCE DESC,
    CODE ASC;