SQL: Table Transformation Lesson 3 Sample Solution

Instruction:
Find flight information about flights where the Federal Aviation Administration region (faa_region) is the Southern region (ASO).

Sample Solution:
SELECT * FROM flights WHERE origin in
(SELECT code FROM airports WHERE faa_region = 'ASO');