team as "Team",

sum(price) as "Total Volume of Sale",

avg(price) as "Average price of Sale"

from flow.core.ez_nft_sales s left join flow.core.dim_allday_metadata m on s.nft_id = m.nft_id and s.nft_collection = m.nft_collection

where

tx_succeeded = true and

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

team is not null

group by 1

order by 2 desc

limit 25