Lesson 2


#1


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



`

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

Why is it SELECT code instead of other things like SELECT id?


#2

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