with cte as (
select m.creator_name, m.creator_address, m.commission_rate, s.creator_fee, s.creator_fee_usd, s.price_usd, s.total_fees
from ethereum.core.dim_nft_metadata m
join ethereum.core.ez_nft_sales s on s.tokenid=m.token_id
where s.creator_fee_usd > 0
)
select creator_name, sum(creator_fee_usd) as Creator_Fee, sum(total_fees) as Total_Fee
from cte
where creator_name is not null
group by creator_name
order by Creator_Fee desc
limit 10