Question 2 non corelated subquries

[hmilyas]

<Hi Im stuck at question 2 ,

https://www.codecademy.com/en/courses/sql-table-transformation/lessons/subqueries/exercises/non-correlated-i?action=resume

Below is the code I used but for some reason it does not work for the question being asked
(Using the same pattern from the example above, find flight information about flights where the origin elevation is less than 2000 feet.)

To me it seemed it like just changing the comparison expression to smaller than.

Does any one know how what is being asked and how to perform the code?

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

<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>

```

Replace this line with your code.

[courseblaster32234]

I have no idea why this works, and the code you posted doesn’t. If anyone could explain that would be awesome

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

[angelalukic]

This variation also worked for me:

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

I originally tried this below code but it didn’t work. I don’t understand why the below nor OP’s answer works when it’s all the exact same?

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

[hmilyas]

Thanks guys for having a look .
It’s weird , I had to restart the browser and the exact code worked .this keeps happening even with the other questions .it makes you wonder if weather the code was correct