1. Download airline.cvs file from the e-learning,
2. Quickly observe the column heading and value in each column.
3. Description of each column heading is as follows
Coulumn heading Description
year The year the month occurred
month The month for which data was collected
carrier The airline code
carrier_name The airline name
airport The airport code
airport_name The airport name
arr_flights # of flights that arrived at the airport
arr_del15 # of flights that arrived >= 15 minutes late
late_aircraft_ct # flights delayed because a previous flight using the same aircraft was late
arr_cancelled # of canceled arrivals
arr_diverted # of scheduled arrivals that were diverted
arr_delay Sum of the delay minutes
4. Create appropriate database, table, attribute name and type
5. Upload the data from airline.csv into table created at step 4.
6. Perform the following write appropriate SQL statement
a) To print distinct carrier, distinct year, distinct airport name
b) To print to first 10 record of year, month, airport name, carrier name and number of arrival at the airport in descending order according to number of arrival
c) To fetch no of cancel arrival for each carrier
f) Display all airport name, year, month for # of flights that arrived at the airport is more than 500 flight
g) Calculate the average delays to security in airport with airport code OAK
h) Find the average of flights that arrived >= 15 minutes late by each carrier
