binhachonFoundation Fees vs Others - Creator fee distribution
    Updated 2022-04-22
    select
    event_platform,
    -- floor(platform_fee * 100 / (price + platform_fee + creator_fee), 0) as platform_fee_perc,
    floor(creator_fee * 100 / (price + platform_fee + creator_fee), 0) as creator_fee_perc,
    count(*) as frequency,
    sum(price) as volume,
    100 * ratio_to_report(frequency) over (partition by event_platform) as percent
    from ethereum.nft_events
    where block_timestamp > getdate() - interval'3 months'
    and price > 0
    group by 1, 2--, 3

    Run a query to Download Data