Skip to contents

SELECT ad.loc_id, ad.airport_name, ef.data_year, ef.enplanements FROM Elmer.faa.airport_dims AS ad JOIN Elmer.faa.enplanement_facts AS ef ON ad.airport_dim_id=ef.airport_dim_id WHERE ad.st='WA' AND ad.airport_dim_id IN(657,671) ORDER BY ad.airport_name, ef.data_year;

Usage

enplanement_example_data

Format

An object of class data.frame with 26 rows and 4 columns.