SQL: Table Transformation (2/7)


#1

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;


#2

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