alirsFB-NFT-07
Updated 2022-10-07
9
1
2
3
4
5
6
›
⌄
select PROJECT_NAME,PLATFORM_NAME, sum(CREATOR_FEE_USD) as royalty_USD,sum(CREATOR_FEE) as royalty,count(DISTINCT PROJECT_NAME) as Project_Count ,
case when royalty=0 and royalty_usd=0 then 'Project with Royalty=0'
else'Project with Royalty>0' end as Royality_type
from ethereum.core.ez_nft_sales
where date(BLOCK_TIMESTAMP)>='2022-02-04' and PLATFORM_NAME='x2y2'
group by 1,2
Run a query to Download Data