A relational schema for a train reservation database is given below.…

A relational schema for a train reservation database is given below.

Passenger(pid, pname, age)

Reservation(pid, class, tid)

What pids are returned by the following SQL query for the above instance of the tables?

SELECT pid
FROM Reservation
WHERE class = 'AC' AND EXISTS (
    SELECT *
    FROM Passenger
    WHERE age > 65 AND Passenger.pid = Reservation.pid
)