,PLATFORM_NAME as "Platform Name"

,count(distinct PROJECT_NAME) as "Number of projects"

,count(distinct NFT_ADDRESS) as "Number of NFTs"

,sum(CREATOR_FEE_USD) /"Number of NFTs" as "Royalty per NFT$"

from ethereum.core.ez_nft_sales

group by 1,2

having sum(CREATOR_FEE_USD) > 0