SELECT
    DISTRICT.DISTRICT_CODE AS CODE
  , DISTRICT.DISTRICT_NAME AS NAME
  , LATITUDE AS LAT
  , LONGITUDE AS LON
  , ROUND(
        SQRT(
            (
                LATITUDE - LAG (LATITUDE) OVER (
                    ORDER BY
                        DISTRICT.DISTRICT_CODE
                )
            ) * (
                LATITUDE - LAG (LATITUDE) OVER (
                    ORDER BY
                        DISTRICT.DISTRICT_CODE
                )
            ) + (
                LONGITUDE - LAG (LONGITUDE) OVER (
                    ORDER BY
                        DISTRICT.DISTRICT_CODE
                )
            ) * (
                LONGITUDE - LAG (LONGITUDE) OVER (
                    ORDER BY
                        DISTRICT.DISTRICT_CODE
                )
            )
        )
      , 3
    ) AS DISTANCE
FROM
    LOCATION_TBL
    LEFT JOIN DISTRICT ON DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE
WHERE
    DISTRICT.DISTRICT_CODE != '1101'
ORDER BY
    DISTANCE DESC
  , DISTRICT.DISTRICT_CODE ASC;