MLDZMNartg10
    Updated 2023-04-13
    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