We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.
alteryx Community

# Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## 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?

17 - Castor

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

17 - Castor
Spoiler

Agree with others on the provided output not being correct

16 - Nebula
Spoiler
5 - Atom

This was fun!

Spoiler
17 - Castor

My solution. I didn't use Join tool.

Spoiler

8 - Asteroid
Spoiler
Solution Attached

16 - Nebula
Spoiler