Table Transformation subqueries 1


#1

<PLEASE USE THE FOLLOWING TEMPLATE TO HELP YOU CREATE A GREAT POST!>
SELECT code
FROM airports
WHERE elevation < 2000;
SELECT *
FROM flights
WHERE origin in (
SELECT code
FROM airports
WHERE elevation < 2000);
please help. I Don’t know why my code doesn’t work.No error message is displayed.
<Below this line, add a link to the EXACT exercise that you are stuck at.>

<In what way does your code behave incorrectly? Include ALL error messages.>

<What do you expect to happen instead?>

```python

Replace this line with your code.

<do not remove the three backticks above>

#2

And what happens if you kick out the code

SELECT code
 FROM airports
 WHERE elevation < 2000;


#3

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