count(distinct tx_id) as sales_count

, sum(price) as sales_amount

, count(distinct buyer) as buyer_count

, count(distinct seller) as seller_count

, max(price) as sales_max

, avg(price) as sales_avg

,team , block_timestamp::date as sales_date

from flow.core.ez_nft_sales as nft

inner join flow.core.dim_topshot_metadata as topshot on

nft.nft_id=topshot.nft_id

and

team in ('Golden State Warriors','Boston Celtics')

where

block_timestamp::date >='2021-10-19' and block_timestamp::date <='2022-06-18'

group by team , sales_date