avg(100*creator_fee/price) as creatorFee,

avg(100*platform_fee/price) as platformFee

FROM ethereum.nft_events

WHERE block_timestamp >= CURRENT_DATE-90

AND event_platform = 'rarible'

AND tx_currency = 'ETH'

AND creator_fee > 0

select 'foundation' as platform,

avg(CASE WHEN event_inputs:ownerRev::integer !=0 THEN 100*event_inputs:creatorFee::integer/(event_inputs:ownerRev::integer+event_inputs:f8nFee::integer+event_inputs:creatorFee::integer) END) as creatorFee,

avg(CASE WHEN event_inputs:ownerRev::integer !=0 THEN 100*event_inputs:f8nFee::integer/(event_inputs:ownerRev::integer+event_inputs:f8nFee::integer+event_inputs:creatorFee::integer) END) as platformFee

FROM Ethereum_core.fact_event_logs

WHERE block_timestamp >= CURRENT_DATE-90

AND event_name = 'ReserveAuctionFinalized'

AND tx_hash != '0xe54aec950ef3bca6890a0623851ae26e65bb0c776148f5d20cd9b16e20123429'