Final Exam - Question 7

In the alliance data in the aggregation database, is the oneworld alliance meant to have Malasya Airlines spelt that way, when in the air_routes table it is spelt Malaysia Airlines,

The same for KLM in skyteam, but in air_routes it is KLM Royal Dutch Airways.

The join from to air_alliances.airline, fails for these airlines.

Is this the reason for the comment in the question

Names are distinct, i.e. Delta != Delta Air Lines

It would seem so! At least it looks like a big hint.


We are aware of those inconsistencies in the names, you can consider them different airlines.

José Carlos


I cobbled together some code, which got me to an answer, which kind of tallies up to the options available.