select BUYER

,PRICE

,NFT_ID

from flow.core.ez_nft_sales

where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay'

and BLOCK_TIMESTAMP>='2022-11-24'

and TX_SUCCEEDED='TRUE'

and BUYER in ('0xfb34edeab0448ef3','0x4b7ad060d826fba2','0x4b5cef0306599709','0x265bd5993c6200c9'

,'0x5162361ea683623e','0x2ab9ed5d1a72cbc2','0x64afebe42165be6e','0x1f28ae193cae956b','0x0ee6d8a7d9a8ca32','0x1c7a492a3388d2d8')),

tab2 as (

select

case

when TEAM in ('Minnesota Vikings','New England Patriots','Dallas Cowboys','New York Giants','Detroit Lions','Buffalo Bills')

then 'Belonging to the teams that played on THG Day' else 'Other Teams' end as team_type

,NFT_ID

,PLAYER

,TEAM

from flow.core.dim_allday_metadata)

select team_type,sum(PRICE)as volume,count(distinct tab2.NFT_ID)as nft_count

from tab1

left join tab2

on tab1.NFT_ID=tab2.NFT_ID

where team_type is not null

group by 1