select BLOCK_TIMESTAMP::date as date

,count(distinct BUYER) as Buyer_Count

,count(distinct NFT_ID) as NFT_Sold_Count

,count(distinct SELLER) as seller_Count

,count(distinct TX_ID) as sales_count

,sum(price) as Sales_Volume

from flow.core.ez_nft_sales

where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay'

and BLOCK_TIMESTAMP>='2022-11-24'

and TX_SUCCEEDED='TRUE'

group by 1),

tab2 as (

select BLOCK_TIMESTAMP::date as date

,count(distinct BUYER) as Buyer_Count

,count(distinct NFT_ID) as NFT_Sold_Count

,count(distinct SELLER) as seller_Count

,count(distinct TX_ID) as sales_count

,sum(price) as Sales_Volume

from flow.core.ez_nft_sales

where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay'

and BLOCK_TIMESTAMP<'2022-11-24'

and TX_SUCCEEDED='TRUE'

group by 1)

select 'After Thanksgiving Day' as thg_day

,avg(Buyer_Count) as "Avg Buyer Count"

,avg(NFT_Sold_Count) as "Avg NFT Sold Count"

,avg(seller_Count) as "Avg Seller Count"

,avg(sales_count) as "Avg Sales Count"

,avg(Sales_Volume) as "Avg Sales Volume"

from tab1

union all

select 'Before Thanksgiving Day' as thg_day

,avg(Buyer_Count) as "Avg Buyer Count"

,avg(NFT_Sold_Count) as "Avg NFT Sold Count"

,avg(seller_Count) as "Avg Seller Count"