gayatridodmaniBored Ape standing amongst other creators
    Updated 2022-12-24
    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
    Run a query to Download Data