Updated 2022-10-08
    select
    PROJECT_NAME as NFTs,
    count(tx_hash) as no_sale,
    count(distinct BUYER_ADDRESS) as no_buyer,
    sum(price_usd) as volume,
    sum(CREATOR_FEE_USD) as Royalty_fee
    from ethereum.core.ez_nft_sales
    where PLATFORM_NAME='rarible'
    and NFTs is not null
    group by 1 having Royalty_fee is not null
    order by 5 desc limit 10

    Run a query to Download Data