SELECT 
DISTRICT_CODE as CODE,
DISTRICT_NAME as NAME,
LAT,
LON
FROM (SELECT 
OTHER.PF_CODE, 
OTHER.DISTRICT_CODE,
OTHER.DISTRICT_NAME,
OTHER.LATITUDE as LAT,
OTHER.LONGITUDE as LON,
SQRT((OTHER.LATITUDE - SAPPORO.LATITUDE) * (OTHER.LATITUDE - SAPPORO.LATITUDE) + (OTHER.LONGITUDE - SAPPORO.LONGITUDE) * (OTHER.LONGITUDE - SAPPORO.LONGITUDE)) as length
FROM (select L.*, D.DISTRICT_NAME FROM LOCATION_TBL L INNER JOIN DISTRICT D ON L.DISTRICT_CODE=D.DISTRICT_CODE WHERE L.DISTRICT_CODE<>'1101') OTHER,
(select LATITUDE, LONGITUDE
   from LOCATION_TBL
  WHERE DISTRICT_CODE='1101') SAPPORO
)
order by LENGTH desc,
CODE ASC;