Sweet Bites: Scary Querying for Treats!

Full SQL model and output can be accessed here

LINE OF THINKING:

• Satisfaction for all, for the purposes of this exercise, means catering to all tastes and preferences, i.e. combos must fulfill all 9 candy attributes
• Optimize satisfaction by choosing the all-catering combo with the highest winpercent/score

STEPS IN SQL:

• Create all possible treat combinations through CROSS JOINs (don't tell Dracula)
• Average percentages across combo components
• Eliminate combos that don't satisfy all 9 candy traits
• Normalize rates from a scale of 0 - 1 to come up with scores
  • Win%: the higher the better
  • Sugar% and Price%: The lower the better

CONCLUSION:

• Based on Win Percent alone, the combo of Snickers, Twix, and Nerds
• Two additional winning combos were initially planned based on win score + sugar scoret and win score + price score, however, one combo satisfied both score schemes: Kitkat, Smarties, Snickers