this is the example that was given, SELECT *
WHERE origin in (
WHERE fac_type = 'SEAPLANE_BASE');
and i was given this instruction
Using the same pattern, find flight information about flights where the Federal Aviation Administration region (faa_region) is the Southern region (ASO)..
this was my query
select * from flights where
(select code from airports where faa_region = 'aso');.
the system can't validate the query