--credit : https://app.flipsidecrypto.com/velocity/queries/f3f538ed-b66c-45c9-b864-59ed46f8fc47 select 'LaLiga Golazos' as project_name, case when price < 1 then 'Less Than $1' when price >= 1 and price < 5 then '$1 - $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' else 'More Than $50' end as type, count (distinct tx_id) as Sales_Count from flow.core.ez_nft_sales where nft_collection = 'A.87ca73a41bb50ad5.Golazos' and block_timestamp >= '2022-11-28 22:12:48.000' and block_timestamp <= '2022-12-05 22:12:48.000' and tx_succeeded = 'TRUE' group by 1,2 union ALL select 'TopShot' as project_name, case when price < 1 then 'Less Than $1' when price >= 1 and price < 5 then '$1 - $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' else 'More Than $50' end as type, count (distinct tx_id) as Sales_Count from flow.core.ez_nft_sales where nft_collection = 'A.0b2a3299cc857e29.TopShot' and block_timestamp >= '2020-10-14 00:42:44.000' and block_timestamp <= '2020-10-21 00:42:44.000' and tx_succeeded = 'TRUE' group by 1,2 union ALL select 'AllDay' as project_name, case when price < 1 then 'Less Than $1' when price >= 1 and price < 5 then '$1 - $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' else 'More Than $50' end as type, count (distinct tx_id) as Sales_Count from flow.core.ez_nft_sales where nft_collection ilike 'A.e4cf4bdc1751c65d.AllDay' and block_timestamp >= '2022-02-23 12:40:58.000' and block_timestamp <= '2022-03-02 12:40:58.000' and tx_succeeded = 'TRUE' group by 1,2 union ALL select 'FIFA+' as project_name, case when total_sales_amount_usd < 1 then 'Less Than $1' when total_sales_amount_usd >= 1 and total_sales_amount_usd < 5 then '$1 - $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' else 'More Than $50' end as type, count (distinct tx_group_id) as Sales_Count from algorand.nft.ez_nft_sales_fifa where sale_type = 'secondary' and block_timestamp >= '2022-10-06 12:45:32.000' and block_timestamp <= '2022-10-13 12:45:32.000' group by 1,2

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