Cacher is the code snippet organizer for pro developers

select SURVEY_YEAR,
       candybar_name,
       gender,
       overall_rating,
       sum(number_bars_consumed) as total_bars_consumed
from CANDYBAR_CONSUMPTION_DATA 
group by rollup(SURVEY_YEAR,candybar_name,gender,OVERALL_RATING);