0-MIDper seller expensive
Updated 2023-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab1 as (
select SELLER
,PRICE
,case
when BLOCK_TIMESTAMP>='2023-03-01' and BLOCK_TIMESTAMP<='2023-03-31' then 'MARCH'
when BLOCK_TIMESTAMP>='2023-04-01' and BLOCK_TIMESTAMP<='2023-04-30' then 'APRIL' end as month_name
from flow.core.ez_nft_sales
where BLOCK_TIMESTAMP>='2023-03-01' and BLOCK_TIMESTAMP<='2023-04-30'
and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'
)
select month_name
,round(max(PRICE)) as ceiling_Sold
from tab1
where month_name is not null
group by 1
Run a query to Download Data