Non-Correlated subqueries I

Get Help SQL
#1

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

#2

It’s coming from airports table not from flights.

#3

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

#4