Flight Delays - Dataset

Using the Flight Delays Dataset 

Learning Objective is to make decisions with data and gain a better understanding of your dataset. 

Are you getting ready for vacation and worrying about the long hours of delay at airports? This is always in the back of our minds as we make a flight reservation, isn't it? Let's look at how bad flight delays were in the summer of 2021, which officially started on June 21 and ended on September 22.

Based on the dataset Flights_2021, which contains a random sample of all the flights in 2021, and the two tables provided, let's find the following information:

1.    What were the five top airlines with more delays that summer?
2.    What Airline had the longest delayed time that summer? On what date?
3.    What were the top five airports with more flights delayed that summer?
4.    How many flights were cancelled that summer?

Note: 
CRS_Dep_Time= Scheduled Departure Time (local time: hhmm)
Dep_Time:  Actual Departure Time (local time: hhmm)    
Dep_Delay: Difference in minutes between scheduled and actual departure time. Early departures show negative numbers.

Source: https://www.transtats.bts.gov/DL_SelectFields.aspx?gnoyr_VQ=FGK&QO_fu146_anzr=b0-gvzr