Updated 2023-08-12
    select
    CASE WHEN (price_USD) <= 500 THEN 'a.below 500'
    WHEN (price_USD) > 500 and (price_USD) <=2000 THEN 'b.500-2000'
    WHEN (price_USD) > 2000 and (price_USD) <=10000 THEN 'c.2000-10000'
    WHEN (price_USD) > 10000 and (price_USD) <=50000 THEN 'd.10000-50000'
    WHEN (price_USD) > 50000 THEN 'e.above 50000'
    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='0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
    and price_usd>0
    group by 1
    Run a query to Download Data