Snowflake Nuggets

https://docs.snowflake.com/en/sql-reference/constructs/group-by-rollup.html  

  https://docs.snowflake.com/en/user-guide/queries-hierarchical.html