Challenge #93: Pumpkin Production

[mike_w]

this one was a little harder then the usual ones categorized as 'Beginner'. But it was also fun - I learned a lot! 

Spoiler

[nimit16]

Admin/Moderator, requires your attention here please..!!

Solution uploaded as per desired result set.

However, IMO, "Min Average State Production" should be computed as the average of the 'minimum' production per state like its computed for  "Max Average State Production".

However in the former, its computed as the overall average of the production per state. So the column value doesn't matches with the column header title in actual sense...!! (marked in the image)

Anyways solution provided to get the desired results.

Spoiler

[mag161]

At first, I thought my solution was unnecessarily long, but it seems that everyone used a lot of joins to make this work. Maybe the challenge should have included, make it work with the least amount of joins as possible. 

[omercado05]

Challenging but fun. Feels like I'm getting more comfortable in using the Dynamic Rename, but a challenge that even with this answer made me wonder about having fewer Joins and/or fewer tools. I do find the solution posted at the top intriguing as well as others here. Good stuff!

[ehughes]

My solution

Spoiler

 

[Arturo90]

This is my solution!

[tclovis]

Challenge #93 solution

[LittleE]

I enjoin you to see my solution!

Spoiler

[DPRC]

Solution Attached (Hopefully, any feedback welcomed)

p.s I now detest pumpkins!

[pawanmalik]

My solution for this challenge.