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

LIMIT 20