MLDZMNhwt9
    Updated 2022-10-24
    with tb1 as (select
    mint,
    count(tx_id) as no_trade,
    count(distinct PURCHASER) as no_buyer,
    count(distinct seller) as no_seller

    from solana.core.fact_nft_sales
    where marketplace = 'hadeswap' and SUCCEEDED='TRUE'

    group by 1 having no_trade>1 and no_buyer=2 and no_seller=2
    )

    select
    distinct PURCHASER as users,
    count(tx_id)
    from solana.core.fact_nft_sales
    where marketplace = 'hadeswap' and SUCCEEDED='TRUE'
    and mint in (select mint from tb1)
    group by 1
    order by 2 desc limit 10
    Run a query to Download Data