case when project_name is null then 'unlabeled_project' else project_name end as project,

count(*) as mints,

count(DISTINCT nft_to_address) as minters,

count(*) / count(DISTINCT nft_to_address) as avg_mints_per_minter

FROM base.core.ez_nft_transfers

WHERE nft_from_address LIKE '0x0000000000000000000000000000000000000000'

GROUP BY 1

ORDER BY 3 DESC