Any Whiskey Containing 'rye' > 'Ryes'
Any Whiskey Containing 'bourbon' > 'Bourbons'
Any Whiskey Containing 'scotch' > 'Scotch'
Any Whiskey not meeting above criteria > ‘Other Whiskey’
Everything Else > ‘All Other’
Join the sales table to the population table to get sales per capita. Make sure to bring in the population for only all ages and genders.
Summarize the results.
Which Month & Category had the highest gross profit $ (growth rate %) MoM?
Which Month & Category had the highest gross profit rate % (growth rate %) MoM?
Which Month & Zip Code had the highest sales per capita growth % MoM for Bourbon?