SQL :Table transformation


Using the same pattern, find flight information about flights where the Federal Aviation Administration region (faa_region) is the Southern region (ASO).

I have no idea ,how to solve it ?anyone can help


You need to use almost the same sentence from the example:

SELECT * FROM flights WHERE origin in ( SELECT code FROM airports WHERE fac_type = 'SEAPLANE_BASE');

just changing the intern query to obtain the code from the table airports where faa_region is equal to ASO

thats all.....


A post was split to a new topic: I can not solve first sentence in transformation table


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.