mattkstewETH OA 4
Updated 2022-12-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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