FAQ: Subqueries - Non-Correlated Subqueries I

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.