project_name as NFT,

sum (total_fees_usd) as "royalty (USD)",

sum(total_fees_usd) / sum(price_usd) * 100 as "average royalty raito"

from ethereum.core.ez_nft_sales

where total_fees_usd is not null

and project_name is not null

and price_usd > 0

group by 1

order by 3

limit 10)

select

NFT

from main