select buyer_address,

count (distinct tx_hash) as TX_Count,

sum (price_usd) as Total_Volume

from ethereum.core.ez_nft_sales

where nft_address = '0x455c732fee7b5c3b09531439b598ead4817d5274'

group by 1),

table2 as (select count (distinct buyer_address) as Buyers_Count from table1),

table3 as (

select t1.buyer_address,

t2.nft_address,

case when nft_address = '0xc7e4d1dfb2ffda31f27c6047479dfa7998a07d47' then 'Aopanda Party' else project_name end as project_name

from table1 t1 left join ethereum.core.ez_nft_sales t2 on t1.buyer_address = t2.buyer_address),

table4 as (

select project_name,

nft_address,

count (distinct buyer_address) as Non_Buyers_Count

from table3

where nft_address != '0x455c732fee7b5c3b09531439b598ead4817d5274' and project_name != 'opensea'

group by 1,2)

select case when nft_address = '0x28472a58a490c5e09a238847f66a68a47cc76f0f' then 'Adidas Originals Into the Metaverse'

when nft_address = '0xba0c9cf4da821dba98407cc4f9c11f6c7a5f9bbc' then 'Adidas Virtual Gear'

else initcap(project_name) end as project_name,

nft_address,

(Non_Buyers_Count/Buyers_Count)*100 as Crossover_Ratio

from table4,table2

order by 3 desc

limit 10