Challenge #93: Pumpkin Production

[nini]

My solution:

[rfergus]

Spoiler

[TharunReddy]

[ipeng]

My solution

[Alekh]

My solution

Spoiler

[sachin02]

my solution(compact with less no. of tools):

[Sajeel_Kershi]

hmm used loads of joins

Summary tool to get total by state and year, summary tool to get min and max for year and then summary tool for state & average. Muliple joining to get all the columns and then a summary tool to calculate Min/Max Average Diff. Finished off with final summary tool to group by all required columns

[Deevi]

It was a nice challenge. Thanks!

Spoiler

[cplewis90]

Who knew so much about pumpkins? All I know is they make a great pie!

Spoiler