Challenge #93: Pumpkin Production

[M-Shedid]

Quick but not too Neat, and that took a lot of joins

[estherb47]

There is likely a more efficient way than this, but I'm playing catch up and need to get through several challenges. Rushing my result seems to mean a lot of tools.

Spoiler

[TimM]

Spoiler

[nick_ceneviva]

Solution attached

[CynthiaE]

Not as many joins (two) but lots of multi-row formulas! 

[JefBus]

 Got it, I think :)

i had to use 4 joins, just discovered the group by function on the sampling tool, thanks!

Spoiler

[maraquindoza]

Attached is my solution! Would love to know how it can be done with lesser joins :)

[MaxGiegerich]

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