Challenge #277: 2016 Summer Olympics

[lkim524]

Improved upon solution set by replacing athlete count null values with 0 so the total counts work (i.e. look at Vanuatu in the output).  I also get slightly different average age values if I find the datediff by "days" instead of "years" and dividing by 365 (which I think is actually more accurate).  I ended up just going back to "years" to match the output average ages.  I also threw out the 1 Russian athlete without a DOB...

[ARussell34]

I used the closing date for the 2016 Olympics for determining the average age of athletes participating for each country.

[JennyMartin]

Spoiler

Video solution here: https://youtu.be/_0dTdZgBNl4

[MilindG]

Spoiler

[simi22]

solved

[acarter881]

Here's my solution.

Spoiler

[Ruban]

😊

[ahsanaali]

[martinding]

Spoiler

 

[daiphuongngo]