,count(distinct BUYER) as buyer_count

,count(distinct NFT_ID) as nft_sold_count

,count(distinct TX_ID) as sales_count

,sum(PRICE) as sales_price

,avg(PRICE) as avg_sales_price

from flow.core.ez_nft_sales

where NFT_COLLECTION='A.87ca73a41bb50ad5.Golazos'

and TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP>='2022-11-28' and BLOCK_TIMESTAMP<='2022-12-06'

union all

select 'NFL ALL DAY'as collection

,count(distinct BUYER) as buyer_count

,count(distinct NFT_ID) as nft_sold_count

,count(distinct TX_ID) as sales_count

,sum(PRICE) as sales_price

,avg(PRICE) as avg_sales_price

from flow.core.ez_nft_sales

where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay'

and TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP>='2022-02-23' and BLOCK_TIMESTAMP<='2022-03-03'

union all

select 'NBA TOP SHOT'as collection

,count(distinct BUYER) as buyer_count

,count(distinct NFT_ID) as nft_sold_count

,count(distinct TX_ID) as sales_count

,sum(PRICE) as sales_price

,avg(PRICE) as avg_sales_price

from flow.core.ez_nft_sales

where NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'

and TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP>='2020-10-14' and BLOCK_TIMESTAMP<='2020-10-22'

union all

select 'FIFA COLLECT+'as collection

,count(distinct PURCHASER) as buyer_count

,count(distinct NFT_ASSET_ID) as nft_sold_count