Abolfazl_771025terra_supply 20
    Updated 2023-01-01
    with main as(select
    DISTINCT MESSAGE_VALUE['sender'] as user,
    count(TX_ID) as "bridge count",
    sum(AMOUNT/1e6) as "bridge volume"
    from terra.core.ez_transfers
    where MESSAGE_TYPE='/ibc.applications.transfer.v1.MsgTransfer'
    and CURRENCY='uluna'
    group by 1)
    select
    case
    when "bridge count" = 1 then 'bridge just one time'
    when "bridge count" between 2 and 5 then 'bridge 2 - 5 time'
    when "bridge count" between 6 and 10 then 'bridge 6 - 10 time'
    when "bridge count" between 11 and 20 then 'bridge 11 - 20 time'
    when "bridge count" between 21 and 50 then 'bridge 21 - 50 time'
    when "bridge count" between 51 and 100 then 'bridge 51 - 100 time'
    when "bridge count" between 101 and 200 then 'bridge 101 - 200 time'
    when "bridge count" between 201 and 500 then 'bridge 201 - 500 time'
    when "bridge count" between 501 and 1000 then 'bridge 501 - 1000 time'
    else 'bridge more than 1000 time'
    end as "bridge count",
    count(user) as "count of bridger"
    from main
    group by 1
    Run a query to Download Data