select SELLER

,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 SELLER in ('0xed8707e2ae5bba5a','0xc4719ab3f4c3db69','0x84c9fe7ef49285fb','0x1ff051563746965f'

,'0xc61bb210bce9722c','0x9cf0e3443ebc8bf9','0xbd803a20e13510e3','0xc3bf9416524fd5e4','0x4e01d2034610cfef','0xe9648003e12c2070')),

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 Thanksgiving 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