I am understanding "origin" in the outer query is matching the faa_region in the inner query and it is producing the correct results.
SELECT * FROM flights WHERE origin in ( SELECT code FROM airports WHERE faa_region = 'ASO');
What I'm not understanding is why "code" is in the select clause of the inner query. What purpose does it serve? It doesn't appear to match anything in the flights table.