MLDZMNvsL2
    Updated 2022-07-16
    with tb1 as (select
    FROM_ADDRESS as users,
    count(distinct TX_HASH) as no_transaction
    from ethereum.core.fact_transactions
    where STATUS='SUCCESS'
    and BLOCK_TIMESTAMP>='2022-01-01'
    group by 1
    )

    select
    case
    when no_transaction=1 then 'One time users'
    when no_transaction>1 then 'More than 1 transaction'
    end as buckets,
    count(distinct users) as count_users
    from tb1
    group by 1
    Run a query to Download Data