We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #325: How many hot dogs can you eat?

Alteryx

A solution to last week’s challenge can be found here.

Every 4th of July since 1972, the Nathan's Hot Dog Eating Contest has been held in Coney Island, a neighborhood of New York City. Nathan's promoters claim that on July 4, 1916, four immigrants held a hot dog eating contest at Nathan's Famous stand on Coney Island to settle an argument about who was the most patriotic.

After this weekly challenge, you might want to eat a hot dog or perhaps not, but either way, you will have fun finding out who eats the greatest number of hot dogs.

Using the dataset provided, answer the following questions:

1) Who was the winner among the male and female contestants for each year?
2) How many hot dogs did the winners eat?
3) What year had the least number of hot dogs eaten by a man and a woman?

16 - Nebula

Nice Challenge didn't quite get the same results as the outputs. Looking forward to seeing what others did.

Spoiler

11 - Bolide

Happy 4th of July!

Spoiler
11 - Bolide

Feeling a bit rusty, might need some of that hotdog grease... Slightly different numbers for the # hotdogs per winner (think the sorting was not right in the proposed output)

Spoiler

16 - Nebula
Spoiler

Agree with others on the provided output not being correct

16 - Nebula
Spoiler
5 - Atom

This was fun!

Spoiler
15 - Aurora

My solution. I didn't use Join tool.

Spoiler

8 - Asteroid
Spoiler
Solution Attached

15 - Aurora
Spoiler