(select

PROJECT_NAME , sum(PRICE_USD)

from

ethereum.core.ez_nft_sales

where

PLATFORM_NAME='blur'

group by 1

order by 2 desc

limit 10)

select

case when BLOCK_TIMESTAMP>'2023-02-14' then 'after airdrop' when BLOCK_TIMESTAMP between '2023-02-01' and '2023-02-14' then 'two week before aordrop' end as type

,PROJECT_NAME , min(PRICE_USD) , max(PRICE_USD) , avg(PRICE_USD)

from

ethereum.core.ez_nft_sales

where

PLATFORM_NAME='blur'

and PROJECT_NAME in (select PROJECT_NAME from t1) and TYPE is not null and PRICE_USD is not null

group by 1,2