symbol,

case when CURRENT_BAL < 0.1 then 'less than 0.1'

when CURRENT_BAL between 0.1 and 1 then 'between 0.1 and 1'

when CURRENT_BAL between 1 and 10 then 'between 1 and 10'

when CURRENT_BAL between 10 and 100 then 'between 10 and 100'

when CURRENT_BAL between 100 and 1000 then 'between 100 and 1000'

when CURRENT_BAL between 100 and 1000 then 'between 1000 and 10000'

when CURRENT_BAL > 1000 then 'greater than 1000'

end AS "holding bag",

count("holding bag") AS "Holders number"

from ethereum.core.ez_current_balances

where CONTRACT_ADDRESS in ('0x45804880de22913dafe09f4980848ece6ecbaf78','0x68749665ff8d2d112fa859aa293f07a622782f38') group by 1,2