team,

moment_tier,

count(distinct tx_id) as "total sales count",

count(distinct buyer) as "total unique user",

sum(price) as "volume",

avg(price) as "avgerage volume"

from flow.core.ez_nft_sales a

join flow.core.dim_allday_metadata d on a.nft_id = d.nft_id

where tx_succeeded = true

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

group by 1,2