Pro exercise

One lookup table, two roles

Each flight has an origin and a destination airport, and both are looked up in the same airport table. Join it twice under different names, so the origin city and the destination city end up in separate columns, and report each kind of unknown airport separately.

joins
dimensions
renaming