Josh956Copy of Mean win
Updated 2022-09-28
9
1
2
3
4
5
6
7
›
⌄
select date_trunc('day', block_timestamp) as day, avg(price), count(*) as "Sales count in a win"
from flow.core.dim_allday_metadata
inner join flow.core.ez_nft_sales
on dim_allday_metadata.nft_id=flow.core.ez_nft_sales.nft_id
where moment_description not like '%win%'
or moment_description not like '%victory%'
group by 1
Run a query to Download Data