'snowflake help to create 3rd variable while grouping

I have a dataset as below, for which i need to group by it by 3 variables also shown as below:

This is my sample data, here you have tokens assigned to each channel, for which few tokens are part of multiple channels, i need to group it by month,channel as show in below image

result needed as below:

I Need the data grouped as below with 3rd category to identify with tokens which is part of multiple channels

sqlsnowflake-cloud-data-platform


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions