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 grouping sets (
(SURVEY_YEAR,candybar_name,gender,OVERALL_RATING),
(SURVEY_YEAR,candybar_name,gender),
(SURVEY_YEAR,candybar_name),
(SURVEY_YEAR),
()
)