0-MIDcount dis sold nft
    Updated 2024-07-06

    with tab1 as (
    select SELLER_ADDRESS
    ,count(distinct TOKENID) as nft_sold
    --,count(distinct TX_HASH) as sell_count
    from base.nft.ez_nft_sales
    group by 1)
    select nft_sold
    --,nft_bought
    ,count(distinct SELLER_ADDRESS) as sellers
    from tab1
    group by 1





    QueryRunArchived: QueryRun has been archived