SELECT

buyer,

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 < 20 THEN 'a Below $20 Sales Volume'

WHEN sales < 100 THEN 'b Between $20 and $100 Sales Volume'

WHEN sales < 1000 THEN 'c Between $100 and $1,000 Sales Volume'

WHEN sales < 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