select
    a.district_code as CODE,
    c.district_name as NAME,
    a.latitude as LAT,
    a.longitude as LON
   
from location_tbl as a
cross join (
    select latitude, longitude
    from location_tbl
    where district_code = 1101) as b
inner join district as c
using(district_code)
where a.district_code <> 1101
order by sqrt((a.latitude - b.latitude) * (a.latitude - b.latitude)
    + (a.longitude - b.longitude) * (a.longitude - b.longitude)) desc,
    1 asc;