SQLize Online / PHPize Online  /  SQLtest Online

select flight_id, point (b.coordinates -a.coordinates) * point((EXTRACT (EPOCH FROM '2017-08-01 12:00:00' - actual_departure)),0) / point((EXTRACT (EPOCH FROM actual_arrival - actual_departure)),0) + a.coordinates as current_coordinates from flights as f join airports_data as a on f.departure_airport = a.airport_code join airports_data as b on f.arrival_airport = b.airport_code where '2017-08-01 12:00:00' between actual_departure and actual_arrival order by 1; select * from query_cost('select flight_id, point (b.coordinates -a.coordinates) * point((EXTRACT (EPOCH FROM ''2017-08-01 12:00:00'' - actual_departure)),0) / point((EXTRACT (EPOCH FROM actual_arrival - actual_departure)),0) + a.coordinates as current_coordinates from flights as f join airports_data as a on f.departure_airport = a.airport_code join airports_data as b on f.arrival_airport = b.airport_code where ''2017-08-01 12:00:00'' between actual_departure and actual_arrival order by 1');