SELECT CODE,
    NAME,
    LAT,
    LON
FROM(
        SELECT t1.DISTRICT_CODE AS CODE,
            t3.DISTRICT_NAME AS NAME,
            t1.LATITUDE AS LAT,
            t1.LONGITUDE AS LON,
            ABS(t1.LATITUDE - t2.LATITUDE) * ABS(t1.LATITUDE - t2.LATITUDE) + ABS(t1.LONGITUDE - t2.LONGITUDE) * ABS(t1.LONGITUDE - t2.LONGITUDE) AS RES
        FROM LOCATION_TBL t1
            JOIN (
                SELECT *
                FROM LOCATION_TBL
                WHERE DISTRICT_CODE = '1101'
            ) t2 ON t1.PF_CODE = t2.PF_CODE
            JOIN DISTRICT t3 ON t1.DISTRICT_CODE = t3.DISTRICT_CODE
    ) tt1
WHERE CODE != '1101'
ORDER BY RES DESC,
    CODE;