player,

count (distinct tx_id) as Sales_Count,

count (distinct buyer) as Buyers_Count,

count (distinct seller) as Sellers_Count,

sum (price) as Total_Sale_Volume

from flow.core.ez_nft_sales join flow.core.dim_allday_metadata using (nft_id)

where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

and tx_succeeded = 'TRUE'

group by 1,2

order by 3 desc

limit 20