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