Non-Correlated subqueries I

Hi there,

I’ve tried to understand where within the flights tables is there a column called elevation or code in order to complete the task provided.

I solved the task but still it’s not clear for me when I execute the SQL those values came from?

This is within topic 2. Non-Correlated Subqueries I. Step 2/7
Thanks

It’s coming from airports table not from flights.

My bad not reading properly what I’m executing, is clearly that the subquery is using airports as you said.

Thanks for your quick answer