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


#1

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

please.


#2

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.


#3

yep, this works. thank you!


#4

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