Skyscanner interview question

SQL query question that was super simple but over complicated by the poor website