select * from solana.core.dim_labels

where label = 'famous fox federation'),

transdimensionalt as (

select * from solana.core.dim_labels

where label = 'transdimensional fox federation'),

table1 as (

select purchaser

from solana.core.fact_nft_sales

where mint in (select address from famoust)

and succeeded = 'TRUE'),

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

table3 as (

select t1.purchaser,

t2.mint,

from table1 t1 left join solana.core.fact_nft_sales t2 on t1.purchaser = t2.purchaser

join solana.core.dim_labels t3 on t2.mint = t3.address

where label is not null),

table4 as (

select label,

count (distinct purchaser) as Non_Buyers_Count

from table3

where mint not in (select address from famoust)

group by 1)

select initcap(label),

(Non_Buyers_Count/Buyers_Count)*100 as Crossover_Ratio

from table4,table2

order by 2 DESC