Is there anyone who would like to help me to solve EX2 of subqueries?

Using the same pattern from the example above, find flight information about flights where the origin elevation is less than 2000 feet.

please.

I just copied and pasted the answered and tweaked the > sign to be a < sign.

SELECT * 
FROM flights 
WHERE origin in (
    SELECT code 
    FROM airports 
    WHERE elevation < 2000);

If it didn’t work try refreshing the browser and trying again, Good luck.

yep, this works. thank you!

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