with r as(SELECT
  LATITUDE,LONGITUDE
FROM
  LOCATION_TBL
WHERE DISTRICT_CODE='1101')
,a AS (
SELECT
  L.*,
  B.LATITUDE b,
  B.LONGITUDE t
FROM
  LOCATION_TBL L,
  r B
),
e as(SELECT
*,
b-LATITUDE as k,
t-LONGITUDE as m
FROM a)
,o as(SELECT
*,
(POWER(k,2)+POWER(m,2)) as j
FROM e)
SELECT o.DISTRICT_CODE as CODE,
DISTRICT_NAME as NAME,
LATITUDE as LAT,
LONGITUDE as LON
FROM o
LEFT JOIN DISTRICT as q on CODE=q.DISTRICT_CODE
WHERE CODE!='1101'
order by j desc,CODE aSC