SELECT

nft_id,

COUNT(DISTINCT tx_id) as sales,

sum(price) as sales_volume,

avg(price) as average_price

FROM flow.core.ez_nft_sales

WHERE split(nft_collection, '.')[2] LIKE '{{nft_collections}}'

AND block_timestamp > CURRENT_DATE - {{first_day}}

AND NOT buyer is NULL

GROUP BY 1

ORDER BY 2 DESC

SELECT

CASE WHEN sales_volume < 10 THEN 'a $10 Sale Volume'

WHEN sales_volume < 50 THEN 'b Between $10 and $50 Sales Volume'

WHEN sales_volume < 100 THEN 'c Between $50 and $100 Sales Volume'

WHEN sales_volume < 1000 THEN 'd Between $100 and $1,000 Sales Volume'

WHEN sales_volume < 10000 THEN 'd Between $1,000 and $10,000 Sales Volume'

ELSE 'e Over $10,000 Sales Volume' end as group1,

COUNT(*)

FROM tab1

GROUP BY 1