Which alliance from air_alliances flies the most routes with either a Boeing 747 or an Airbus A380 (abbreviated 747 and 380 in air_routes)?
Hi, I felt the above question is incomplete or confusing. I spent a lot of time to identify the matching field between air_routes and air_alliances collection and also on which field should I use to run a regex search for conditions 747 and 380. However the previous posts from discussion forum helped to understand the question better and solve it.
I request the team to keep the question simple and easy to understand and make the solution part of it more interesting and challenging. Here the question seems complex to understand but the framing the query and deriving the answer seems fairly straight forward.