A solution to last week’s challenge can be found here.
It's vacation time. Will your flight leave on time?
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 canceled that summer?
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.
Thank you for your comments, this challenge has been updated.