from flow.core.ez_nft_sales s

left join flow.core.dim_allday_metadata m

on s.nft_id = m.nft_id

where s.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

player,

count(distinct tx_id) as no_of_txs,

sum(price) as volume,

count(distinct buyer) as no_of_buyers,

count(distinct seller) as no_of_sellers,

min(price) as min_price,

max(price) as max_price,

median(price) as median_price,

avg(price) as avg_price

from req_tab

where player is not null

and player <> 'N/A'

group by 1

order by 2 desc