with a as(SELECT
  *,
  FIRST_VALUE(LATITUDE) OVER (ORDER BY (SELECT NULL)) AS b,
  FIRST_VALUE(LONGITUDE) OVER (ORDER BY(SELECT NULL)) as t
FROM
  LOCATION_TBL)
,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