select a.DISTRICT_CODE as CODE, a.DISTRICT_NAME as NAME, b.LATITUDE as LAT, b.LONGITUDE as LON 
from DISTRICT as a 
inner join LOCATION_TBL as b on a.DISTRICT_CODE = b.DISTRICT_CODE
order by POW(43.044502-b.LATITUDE, 2)+POW(141.354139-b.LONGITUDE, 2) desc, a.DISTRICT_CODE asc;