mattkstewETH OA 4
    Updated 2022-12-21
    with tab1 as (
    select
    price_usd


    from ethereum.core.ez_nft_sales
    where project_name like 'boredapeyachtclub'
    and block_timestamp > '2020-05-01'
    )

    select
    Case when price_usd between 0 and 20000 then 'Between 0 and 20k USD'
    when price_usd between 20000 and 50000 then 'Between 20k and 50k USD'
    when price_usd between 50000 and 100000 then 'Between 50k and 100k USD'
    when price_usd between 100000 and 250000 then 'Between 100k and 250k USD'
    when price_usd between 250000 and 1000000 then 'Between 250k and 1M USD'
    else 'Greater than 1M USD'
    End as NFT_Price_Distribution,
    count(*)

    from tab1
    group by 1
    Run a query to Download Data