Login
my SQL
765 просмотров
Перейти к просмотру всей ветки
in Antwort melodi_ 27.05.21 17:25
Мой стейтмент:
select f.icao_code_origin, f1.icao_code_destination from flightexecution f, flightexecution f1 where f.icao_code_origin like 'EDDT' and f.icao_code_destination not like 'EDDT'
and f1.icao_code_origin not like 'EDDT' and f.icao_code_destination like 'EDDT' and f.flight_duration_minutes <= 720 and f1.flight_duration_minutes <= 720
having TIMESTAMPDIFF(hour, DATE_ADD(f.departure_date_time_utc, INTERVAL f.flight_duration_minutes MINUTE), f1.departure_date_time_utc) >= 4
and TIMESTAMPDIFF(hour, DATE_ADD(f.departure_date_time_utc, INTERVAL f.flight_duration_minutes MINUTE), f1.departure_date_time_utc)<=25;