case

when deposits < 8 then 'a. Less than UST 8'

when deposits = 8 then 'b. UST 8'

when deposits >8 and deposits <= 20 then 'c. UST >8 - 20'

when deposits >20 and deposits <= 50 then 'd. UST >20 - 50'

when deposits >50 and deposits <= 100 then 'e. UST >50 - 100'

when deposits > 100 then 'f. More than UST 100' end as block,

count(tx_id)

tx_id,

msg_value:amount[0]:amount / pow(10,6) as deposits

from terra.msgs

where msg_value:to_address = 'terra1dax9mddsycvzkc429wwy494vhzhggw3d5594rt'

and block_timestamp < '2021-11-10T02:00:00Z'

and tx_status = 'SUCCEEDED')

group by block

order by block