SELECT FirstName, LastName, Age
FROM Passengers as p
LEFT JOIN Tickets as t on p.Id = t.PassengerId
WHERE t.FlightId is null
ORDER BY age DESC, FirstName, LastName