I wonder if the solution is correct.
In the data the
747 is also noted as
744 (abbrevation for 747-400 model ?).
There are also 74M variant, maybe 742, 743 for the old Queen Of the Skies or 748 for the latest generation.
Using /74.|380/ in the regex returns much more routes (747 amazingly) and One World takes the lead.
There is also an issue with KLM airline that has is “KLM Royal Dutch Airlines” in the routes but only “KLM” in the air alliance, then does not JOIN in the lookup.
Good lab anyway… and good training.