data_cte as (

select

platform_name

, sum(CREATOR_FEE_USD) royalty

from ethereum.core.ez_nft_sales

where 1=1

and BLOCK_TIMESTAMP::date >= '2022-01-01'

and platform_name in ('opensea', 'looksrare', 'x2y2')

group by 1

)

, opensea_cte as (

select * from data_cte where platform_name = 'opensea'

)

select

a.platform_name

, a.royalty

, b.royalty opensea_royalty

, opensea_royalty / a.royalty opensea_vs_platform_royalty

from data_cte a

join opensea_cte b

where a.platform_name != 'opensea'