flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
count dis bought nft
0-MID
count dis bought nft
Updated 2024-07-06
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with
tab1
as
(
select
BUYER_ADDRESS
,
count
(
distinct
TOKENID
)
as
nft_bought
--,count(distinct TX_HASH) as buy_count
from
base
.
nft
.
ez_nft_sales
group
by
1
)
select
--buy_count
nft_bought
,
count
(
distinct
BUYER_ADDRESS
)
as
Buyers
from
tab1
group
by
1
Results
QueryRunArchived: QueryRun has been archived