I am not sure I understand the problem correctly.
Here is the problem:
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)?
Here is how it came across to me:
If you take all routes, you filter it to only include “747” or “380”, which alliance flies the most.
My other theory of the question is:
Which alliance flies the most of its routes with one of the specified airplanes compared to all its routes?
I got it as “OneWorld” for both possibilities of the question. This is a wrong answer.
What am I missing?
Please do not help me with the answer, only with the question.