with rad as(
select radians(ad.coordinates[0]) as Lat1, radians(ad.coordinates[1]) as Lon1, radians(ad2.coordinates[0])as Lat2, radians(ad2.coordinates[1]) as Lon2, ad.airport_code as Otpr, ad2.airport_code as Pril 
from airports_data ad
inner join airports_data ad2 on ad.airport_code = ad2.airport_code)
select acos(sin(rad.Lat1) * sin(rad.Lat2) + cos(rad.Lat1) * cos(rad.Lat2) * cos(rad.Lon1 - rad.Lon2)), fv.departure_airport_name, fv.arrival_airport_name
from rad
inner join flights_v fv on fv.departure_airport = rad.Otpr
inner join flights_v fv2 on fv2.arrival_airport = rad.Pril
where fv.departure_airport_name != fv.arrival_airport_name