project_name, count (distinct tx_hash) as count_transactions,

count (distinct buyer_address) as count_users,

ifnull(sum(price_usd),0) as volume

from

ethereum.core.ez_nft_sales,

ethereum.core.dim_labels where nft_address = address

and project_name is not null and project_name != 'opensea' AND

price_usd > 0 and block_timestamp >= '2022-01-01' and block_timestamp < '2023-01-01'

group by 1 order by 3 desc

limit {{count_projects}}