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 < 5 THEN 'a Below 5 Sales'

WHEN sales < 10 THEN 'b Between 5 and 10 Sales'

WHEN sales < 100 THEN 'c Between 10 and 100 Sales'

WHEN sales < 1000 THEN 'd Between 100 and 1,000 Sales'

ELSE 'e Over 1,000 Sales' END as GROUP1,

COUNT(*)

FROM tab1

GROUP BY 1