from terra.msgs

where tx_module = 'tx' and date(block_timestamp) >= CURRENT_DATE - 90

and tx_status = 'SUCCEEDED' and msg_module = 'wasm' and msg_type = 'wasm/MsgExecuteContract'

),

categories as (select address, date, sum(balance) as luna_balance, case

when luna_balance < 10 then '1. <10'

when luna_balance between 10 and 100 then '2. 10-100'

when luna_balance between 100 and 1000 then '3. 100-1000'

when luna_balance between 1000 and 10000 then '4. 1000-10,000'

when luna_balance between 10000 and 100000 then '5. 10,000-100,000'

when luna_balance between 100000 and 1000000 then '6. 100,000-1,000,000'

else '7. >1M' end as balance_group

from terra.daily_balances

where date = CURRENT_DATE - 1 and currency = 'LUNA' and address in (select addresses from active)

group by 1,2)

select balance_group, count(address)

from categories

group by 1

order by 1 asc