MLDZMNportal1
    Updated 2022-12-23
    with tb1 as (
    select
    Label,
    ADDRESS as mints
    from solana.core.dim_labels
    where LABEL ilike 'portals'),

    tb4 as (select
    distinct purchaser as sender,
    count(distinct TX_ID) as no_transaction
    from solana.core.fact_nft_mints x
    left join tb1 a on x.mint=a.mints
    where mint in (select mints from tb1)
    and label!='portals.art'
    group by 1)

    select
    case
    when no_transaction=1 then 'One time minter'
    when no_transaction>1 and no_transaction <5 then '1-5 times minter'
    when no_transaction>5 then 'More than 5 times minter'
    end as gp,
    count(distinct sender)
    from tb4
    group by 1 having gp is not null
    Run a query to Download Data