Updated 2022-11-27
    with
    main as (
    select
    DISTINCT SENDER,
    count(BLOCK_ID) as TRANSACTIONS
    from axelar.core.fact_transfers
    where TRANSFER_TYPE = 'IBC_TRANSFER_IN'
    and TX_SUCCEEDED = 'TRUE'
    GROUP by 1
    order by 2 DESC
    )
    select
    case
    when (TRANSACTIONS) <= 1 then 'low than 1 bridge'
    when (TRANSACTIONS) > 1 and (TRANSACTIONS) < 10 then 'between 1 - 10 bridge'
    when (TRANSACTIONS) >= 10 and (TRANSACTIONS) < 100 then 'between 10 - 100 bridge'
    when (TRANSACTIONS) >= 100 then 'more than 100 bridge'
    else 'null'
    end as type,count(SENDER) from main GROUP by 1 order by 2 DESC
    Run a query to Download Data