the commonality are ‘origin’ column id flights and ‘code’ in airports;
you can join two table on that, but i is longer than using subqueries
A non-correlated subquery is a subquery that can be run independently of the outer query and as we saw, can be used to complete a multi-step transformation.