Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAhmm 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
It was a nice challenge. Thanks!
Who knew so much about pumpkins? All I know is they make a great pie!