boomer77pooly 2
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with raw as (select *, case
when nft_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' then 'supporter'
when nft_address = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' then 'lawyer'
when nft_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'judge'
end as pooly
from ethereum.core.ez_nft_transfers
where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523') and event_type = 'mint')
select pooly, count(tokenid) as mint_count, count(distinct nft_to_address) as address_count
from raw
group by 1
Run a query to Download Data