select PLATFORM_NAME,

sum (PRICE_USD) volume

from ethereum.core.ez_nft_sales

group by 1 order by volume desc limit 3

select PROJECT_NAME,

PLATFORM_NAME,

(sum (creator_fee_usd) / sum(price_usd)) * 100 as Percentage_Royalty_fee

from ethereum.core.ez_nft_sales

where PLATFORM_NAME in (select PLATFORM_NAME from Top3)

and creator_fee_usd >=0

and price_usd > 0

group by 1,2 order by Percentage_Royalty_fee desc limit 10