MLDZMNcrossover1
    Updated 2023-09-01
    with tb1 as (select
    distinct BUYER_address as sender
    from ethereum.core.ez_nft_sales
    where NFT_ADDRESS='0x790b2cf29ed4f310bf7641f013c65d4560d28371'
    group by 1)

    select
    Project_NAME as NFTs,
    count(distinct BUYER_address) as no_buyers
    from ethereum.core.ez_nft_sales
    where NFT_ADDRESS !='0x790b2cf29ed4f310bf7641f013c65d4560d28371'
    and buyer_address in (select sender from tb1)
    group by 1 having NFTs is not null
    order by 2 desc
    limit 10
    Run a query to Download Data