alirsFB-NFT-07
    Updated 2022-10-07
    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