MLDZMNprofile 7
    Updated 2022-07-07
    with tbt as (select
    distinct swapper,
    count(distinct TX_GROUP_ID) as times
    from flipside_prod_db.algorand.swaps
    where BLOCK_TIMESTAMP between '2022-05-01' and '2022-06-30'
    group by 1)

    select
    case
    when times=1 then 'Only one swap'
    when times>1 then 'More than 1 swap'
    end as buckets,
    count(distinct swapper) as count_users
    from tbt
    group by 1
    Run a query to Download Data