Challenge #328: Booking a Flight? Think Twice!

[AkimasaKajitani]

My solution.

Spoiler

I could not match the answer to #4 question.

[RWvanLeeuwen]

I always hope for the best when joining fields I don't know, but in this case it worked out jolly well

Spoiler

[FloSchoch]

I'm a little confused...
How can a flight be canceled and still depart?

I guess those 39 records are wrong in the dataset?!?

I'm not finished by now because i always get confused by inconsistent inputs 😅

[RolandSchubert]

Spoiler

Different results, because I didn't include delays for cancelled flights in count.

[RobertMika]

Here we go

[MilindG]

Spoiler

[phottovy]

Never been more proud to be from Denver! 

[Clifford_Coon]

Solution Attached:

Notes:

1. Results indicate total minutes, but in fact the results are total number of delays

2. The results include cancelations (where a positive delay in minutes is given), rather than treating cancelations as a distinct item. Given that logic all cancelations could be included (infinite minutes delay)

3. Total number of flights canceled result seems to be an incorrect value

[ARussell34]

I just wanted to point out that the counts for part 1 and 3 were for total occurrences and not total delayed minutes. Additionally, part 4 I have total number of cancelations for the whole year of 2021 based on the data set provided. 

[Qiu]

I was misled by "in minutes" actually should be Count😁

Spoiler