MLDZMNENI8
    Updated 2023-01-04
    select
    CASE
    WHEN PRICE_USD < 5 then 'a. Below 5'
    WHEN PRICE_USD < 100 then 'b. 5 - 100'
    WHEN PRICE_USD < 500 then 'c. 100 - 500'
    WHEN PRICE_USD < 2000 then 'd. 500 - 2,000'
    WHEN PRICE_USD >= 2000 then 'e. Over 2,000'
    end as gp,
    count(distinct tx_hash) as sale_no,
    count(distinct BUYER_ADDRESS) as buyer_no
    from ethereum.core.ez_nft_sales
    where PRICE_USD::float > 0
    and price>0
    and BLOCK_TIMESTAMP between '2022-01-01' and '2023-01-01'
    group by 1
    Run a query to Download Data