Skyscanner Interview Question

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