MLDZMNmgf20
    Updated 2023-03-14
    with tb2 as (select
    tx_from as wallets,
    count(distinct tx_id) as frequency
    from solana.core.fact_transfers
    where mint = 'So11111111111111111111111111111111111111112'
    and block_timestamp >= '2022-02-08'
    and tx_to = 'DD3AeAssFvjqTvRTrRAtpfjkBF8FpVKnFuwnMLN9haXD'
    group by 1
    union all
    select
    tx_from as wallets,
    count(distinct tx_id) as frequency
    from solana.core.fact_transfers
    where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and block_timestamp >= '2022-02-08'
    and tx_to = '3uxNepDbmkDNq6JhRja5Z8QwbTrfmkKP8AKZV5chYDGG'
    group by 1
    )



    select
    case
    when frequency=1 then 'One time use'
    when frequency>1 and frequency<=5 then '2-5 time use'
    when frequency>5 then 'More than 5 times use'
    end as bucket,
    count (distinct wallets) as no_users
    from tb2
    GROUP by 1
    Run a query to Download Data