Challenge #277: 2016 Summer Olympics

[dYoast]

I don't have the same results for average age, but I did include totals for all countries.

Trying a spoiler for the first time.

Spoiler

[ggruccio]

Used 8-5-2016 as the start date for the Rio Olympics.

Spoiler

Fairly simple separate data calculations - brought back together at the end of the data stream.  

[achillesjing]

Here is my solution

[mike_w]

As a few others have mentioned - I also get results different from the solution provided. Using the CreW Expect Equal Tool reveals the issues, there's a handful or so errors: So for example it says there's a problem in row 23; checking the solution provided, row 23 is Bhutan with 2 Female Athletes, 0 (or [Null]) Male Athletes - and then [Null] Total Athletes!  That can't be right. 

Spoiler

[Elias_Nordlinder]

My solution, also get 5 records wrong because not correct value in output given as for other people.

Spoiler

[ryan-bush]

Fun and timely challenge! '2016-08-05' for the age calculation is a useful tip

[Michael_McKee]

This was a fun one

[phottovy]

I don't think I'll make the podium for my time on this one.

Spoiler

[kelly_gilbert]

I love these summary/fact-finding challenges! Like others, I had a couple of discrepancies in the total athlete counts likely due to null counts for one of the genders (I'm pretty sure my solution is correct).

Spoiler

My workflow:

Differences from the solution:

Fun fact: one of my colleagues is an athlete in this dataset!

[Qiu]

Thanks for the tip from @Blake , be careful with the age.

Spoiler