select Passengers.Passengerid as "PassengerId", Classes.Class_Name as
"Passenger_Class", Passengers.Name, Passengers.Sex,Passengers.Age,
Travels.Ticket,Travels.Fare, Ports.Port_ID as "Embarked",Ports.Port_ID as
"Destination" from Passengers
inner join Travels on Passengers.Passengerid = Travels.Passengerid
inner join Travel_Options on Travels.Travel_ID = Travel_Options.Travel_ID
inner join Ports on Travel_Options.Origin_Port_ID =  Ports.Port_ID
inner join Ports on Travel_Options.Destination_ID =  Ports.Port_ID
inner join Classes on Travel_Options.Class_ID = Classes.Class_ID;