UPDATE Passenger
SET STATUS = „ia“
WHERE passengerId NOT IN
(
SELECT p.passengerId
FROM Passenger p, Seat_Booking sb, Seat s, Flight f
WHERE
p.passengerId = sb.Passenger_passengerId AND f.flightId = s.Flight_flightId AND
sb.Seat_seatid = s.seatId AND
f.datearr > $actual_date – 5 let
)