MLDZMNartg10
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
CASE WHEN (price) <= 12 THEN 'a.below 12 ETH'
WHEN (price) > 12 and (price) <=15 THEN 'b.12-15 ETH'
WHEN (price) > 15 THEN 'c.above 15 ETH'
END as buckets,
count(distinct tx_hash) as sale_no,
count(distinct BUYER_ADDRESS) as buyer_no
from ethereum.core.ez_nft_sales
where NFT_ADDRESS=lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
group by 1
Run a query to Download Data