Store dataset http://stat-computing.org/dataexpo/2009/the-data.html (year 2007 + additional data from http://stat-computing.org/dataexpo/2009/supplemental-data.html only Airports and Carrier Codes)
-
Count total number of flights per carrier in 2007
-
The total number of flights served in Jun 2007 by NYC
-
Find five most busy airports in US during Jun 01 - Aug 31
-
Find the carrier who served the biggest number of flights (Make screenshot #4.1 and 4.2)
-
Find all carriers who cancelled more than 1 flights during 2007, order them from biggest to lowest by number of cancelled flights and list in each record all departure cities where cancellation happened.