date_trunc('month', block_timestamp) as month,

tx_caller_address,

count(distinct tx_id) as unstakes_count

from osmosis.core.fact_staking

where currency = 'uosmo'

and action = 'undelegate'

and tx_status = 'SUCCEEDED'

group by 1,2)

select

case

when unstakes_count = 1 then '1 in month'

when unstakes_count > 1 and unstakes_count <= 10 then '2 to 10 in month'

when unstakes_count > 10 and unstakes_count <= 20 then '11 to 20 in month'

when unstakes_count > 20 and unstakes_count <= 30 then '21 to 30 in month'

when unstakes_count > 30 and unstakes_count <= 40 then '31 to 40 in month'

when unstakes_count > 40 and unstakes_count <= 50 then '41 to 50 in month'

when unstakes_count > 50 then 'More than 50 in month'

end as tag,

count(distinct tx_caller_address)

from unstakes

group by 1