Challenge #93: Pumpkin Production

[MaxGiegerich]

I think mine's simpler. But then I would I suppose... Pretty satisfying challenge though!

[Charity_K_Wilson]

Spoiler

[LandonG]

Solution attached.

[PhilipMannering]

Solution attached.

Spoiler

[data_rachel]

Spoiler

Lots of joins and a couple of summarise?

[ggruccio]

Never would have thought of the top state as the top state.

[samN]

Not the prettiest, but functional

[LalaLele66]

I tackled this a little different than others, but got to the same end result! I tried to cleanse as much as I could before the first join. After that, I became join crazy. 

Happy New Year! Looking forward to more challenges.

[SeanAdams]

Fun & Quick.

We are in the Andaman Islands at the moment, so it’s pretty tough to get internet access.   On Havelock Island, it seems that there’s only a few places that have WiFi, and it’s very intermittent.

The upside is that the scenery isn’t too bad 😊

Very similar solution to those provided by other folk first:

Spoiler

• Would have been good to use the dynamic rename like @patrick_digan; @NicoleJohnson; @LordNeilLord; @elamm43; @jamielaird; @Goldenboi; @mrichards; @LandonG
• Seems that many used a formula to get rid of commas – I was super lazy and used Cleanse (as did @Charity_K_Wilson)
• Also wonder if I should have use Find-Replace instead of join like @NicoleJohnson;
• Interesting that @data_rachel did all the summaries first before joining to the state info- nice idea.
  
  
  

[jasperlch]

Solution attached.