adambalaUA11
Updated 2023-05-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with a as
(select buyer_address ,count(distinct tx_hash) as tx
FROM ethereum.core.ez_nft_sales
where EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and NFT_ADDRESS=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
group by 1)
select
count(distinct buyer_address) as users,
case
when tx = 1 then '1'
when tx = 2 then '2'
when tx = 3 then '3'
when tx = 4 then '4'
when tx = 5 then '5'
when tx between 5 and 10 then '5 - 10'
when tx between 10 and 15 then '10 - 15'
when tx > 15 then 'more than 15 '
end as "number of transactions for buyers"
from a
group by 2
Run a query to Download Data