sales.tx_id,

allday.nft_id as nft_id,

allday.player as player,

allday.team as team,

allday.play_type as play_type,

allday.set_name as set_name,

allday.classification as classification,

allday.moment_date::date as moment_date,

sales.block_timestamp as sale_date,

sales.buyer as buyer,

sales.seller as seller,

sales.currency,

sales.price as price

from flow.core.dim_allday_metadata as allday

join flow.core.ez_nft_sales as sales

on allday.nft_id = sales.nft_id

and allday.nft_collection = sales.nft_collection

SELECT

team,

COUNT(*) as count

from all_day

group by team