MLDZMNcrossover1
Updated 2023-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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