In this lesson, I understand that we are trying to pick from a subset of the data in Airports, but I am confused by some of the data in the “code” column of Airports. For example, the city Reading in Airports has “elevation” = 1650 but a “code” = 19NY. Though under an elevation of 2000, this location will never show up in our query b/c the “origin” column in Flights only uses data with 3-characters and only letters. Am I missing something obvious here?
I compared the following:
select code, city, elevation from airports;
select origin from flights
order by origin asc;