select 'LALIGA GOLAZOS'as collection ,case when PRICE>0 and PRICE<=5 then 'Below 5 $' when PRICE>5 and PRICE<=10 then '5 ~ 10 $' when PRICE>10 and PRICE<=25 then '10 ~ 25 $' when PRICE>25 and PRICE<=50 then '25 ~ 50 $' when PRICE>50 then 'Up To 50 $' end as dis_volume ,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 ,max(PRICE) as max_sales_price ,min(PRICE) as min_sales_price ,median(PRICE) as med_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' and dis_volume is not null Group by 1,2 union all select 'NFL ALL DAY'as collection ,case when PRICE>0 and PRICE<=5 then 'Below 5 $' when PRICE>5 and PRICE<=10 then '5 ~ 10 $' when PRICE>10 and PRICE<=25 then '10 ~ 25 $' when PRICE>25 and PRICE<=50 then '25 ~ 50 $' when PRICE>50 then 'Up To 50 $' end as dis_volume ,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 ,max(PRICE) as max_sales_price ,min(PRICE) as min_sales_price ,median(PRICE) as med_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' and dis_volume is not null Group by 1,2 union all select 'NBA TOP SHOT'as collection ,case when PRICE>0 and PRICE<=5 then 'Below 5 $' when PRICE>5 and PRICE<=10 then '5 ~ 10 $' when PRICE>10 and PRICE<=25 then '10 ~ 25 $' when PRICE>25 and PRICE<=50 then '25 ~ 50 $' when PRICE>50 then 'Up To 50 $' end as dis_volume ,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 ,max(PRICE) as max_sales_price ,min(PRICE) as min_sales_price ,median(PRICE) as med_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' and dis_volume is not null Group by 1,2 union all select 'FIFA COLLECT+'as collection ,case when TOTAL_SALES_AMOUNT_USD>0 and TOTAL_SALES_AMOUNT_USD<=5 then 'Below 5 $' when TOTAL_SALES_AMOUNT_USD>5 and TOTAL_SALES_AMOUNT_USD<=10 then '5 ~ 10 $' when TOTAL_SALES_AMOUNT_USD>10 and TOTAL_SALES_AMOUNT_USD<=25 then '10 ~ 25 $' when TOTAL_SALES_AMOUNT_USD>25 and TOTAL_SALES_AMOUNT_USD<=50 then '25 ~ 50 $' when TOTAL_SALES_AMOUNT_USD>50 then 'Up To 50 $' end as dis_volume ,count(distinct PURCHASER) as buyer_count ,count(distinct NFT_ASSET_ID) as nft_sold_count ,count(distinct TX_GROUP_ID) as sales_count ,sum(TOTAL_SALES_AMOUNT_USD) as sales_price ,avg(TOTAL_SALES_AMOUNT_USD) as avg_sales_price ,max(TOTAL_SALES_AMOUNT_USD) as max_sales_price ,min(TOTAL_SALES_AMOUNT_USD) as min_sales_price ,median(TOTAL_SALES_AMOUNT_USD) as med_sales_price from algorand.nft.ez_nft_sales_fifa where SALE_TYPE='secondary' and BLOCK_TIMESTAMP>='2020-10-06' and BLOCK_TIMESTAMP<='2022-10-14' and dis_volume is not null Group by 1,2

Flipside's World Cup of Bounties Side Quest: LaLiga Golazos