Final: Question 7

Dear Jose,

Here we getting close to the end, and i come up with this sentence that says:

find which alliance has the most unique carriers(airlines) operating between the airports JFK and LHR

what exactly make the operating airline unique?

Hi,

To avoid counting duplicate airlines, you should use the airline.id field in the air_routes collection.

José Carlos

1 Like

so i need to fetch distinct data, Thank you. one airline may have duplicate route or one airline may be member of several alliance ? --Not that it makes differences…

i missed the bidirectional match and got the answer right.

Looking at the answer, am i lucky because the bidirectionality is data duplication given that the question is asking for direct flights between source and destination?

Or the questions needs to re framed as any fights between the destination with zero or more stoppages?

thanks in advance