MakeMyTrip interview question

SQL join question.. basic puzzles..etc.