topic Re: Challenge #277: 2016 Summer Olympics in Weekly Challenges

Challenge #277: 2016 Summer Olympics

AYXAcademy — Tue, 13 Sep 2022 14:51:02 GMT

A solution to last week’s challenge can be found here.https://commons.wikimedia.org/wiki/File:Olympic_rings_without_rims.svg

As we gear up for the 2021 Summer Olympics, let's take a look back at the countries and athletes that participated in the last Summer Olympics.

- The "athletes" dataset contains data about the athletes who competed in the 2016 Summer Olympics in Rio de Janeiro.
- The "countries" dataset contains the International Olympic Committee country code.

Find the following for each country:
- The sport with the most athletes
- The total number of athletes
- The total number of female athletes
- The total number of male athletes, and
- The average age of all athletes for each country

Hint for the 2016 Summer Olympics

Opening Date: August 5^th, 2016

Closing Date: August 21^st, 2016

Re: Challenge #277: 2016 Summer Olympics

philipmannering — Mon, 19 Jul 2021 13:55:48 GMT

Sprint finish.

Looks like there's a few erroneous nulls in the solution. This will be because a number + Null() = Null(). Gotta zero those nulls first.

Re: Challenge #277: 2016 Summer Olympics

Aaron_Harter — Mon, 19 Jul 2021 12:59:21 GMT

Let the games begin!

Re: Challenge #277: 2016 Summer Olympics

Blake — Mon, 19 Jul 2021 13:13:20 GMT

Made sure to use the start date for the Rio Olympics when calculating the athlete's ages.

Re: Challenge #277: 2016 Summer Olympics

jferrone — Mon, 19 Jul 2021 13:30:03 GMT

Solution to this week's challenge is attached. Age calculation is a bit unclear, but appears to be based on 2016-08-05. I copied that item from @Aaron_Harter solution.

Re: Challenge #277: 2016 Summer Olympics

balajilolla — Mon, 19 Jul 2021 13:32:50 GMT

Solution Attached

Re: Challenge #277: 2016 Summer Olympics

JasonHu — Mon, 19 Jul 2021 13:36:59 GMT

Here is my submission; you need to find out the average age in the year 2016!

Re: Challenge #277: 2016 Summer Olympics

Kenda — Mon, 19 Jul 2021 13:41:19 GMT

Re: Challenge #277: 2016 Summer Olympics

DeanWest — Mon, 19 Jul 2021 13:58:28 GMT

Fun challenge! 😀

Re: Challenge #277: 2016 Summer Olympics

Jishnu_K — Mon, 19 Jul 2021 14:02:37 GMT

Good

Re: Challenge #277: 2016 Summer Olympics

JITHINPR — Mon, 19 Jul 2021 14:05:56 GMT

my solution

Re: Challenge #277: 2016 Summer Olympics

patrick_digan — Mon, 19 Jul 2021 14:20:28 GMT

Re: Challenge #277: 2016 Summer Olympics

Toons — Mon, 19 Jul 2021 14:25:39 GMT

My solution :

Re: Challenge #277: 2016 Summer Olympics

kunderwood — Mon, 19 Jul 2021 14:38:29 GMT

Fun challenge!

Re: Challenge #277: 2016 Summer Olympics

Maskell_Rascal — Mon, 19 Jul 2021 14:55:24 GMT

Is plate throwing really an Olympic sport?

Let's discus! 😆

Here is my solution:

Cheers!

Phil

Re: Challenge #277: 2016 Summer Olympics

natalie_ruppi — Mon, 19 Jul 2021 15:07:47 GMT

Fun challenge!

Re: Challenge #277: 2016 Summer Olympics

RolandSchubert — Mon, 19 Jul 2021 15:21:03 GMT

My solution.

Re: Challenge #277: 2016 Summer Olympics

sukanya_T_P — Mon, 19 Jul 2021 15:26:35 GMT

My solution

Re: Challenge #277: 2016 Summer Olympics

SeanMichael — Mon, 19 Jul 2021 16:21:16 GMT

Great Challenge!!!

Re: Challenge #277: 2016 Summer Olympics

TonyA — Mon, 19 Jul 2021 16:59:35 GMT

Wasn't clear whether "id" was specific to the athlete so I added a check to make sure that an athlete didn't compete in multiple sports (looking at name, dob, height, and weight). There were bad totals based on adding a number to a null in some rows.

I noticed that the "Total Row" function in Crosstab ignores nulls. I think this is because it totals the values before pivoting, so the null values haven't been created yet.