select * from solana.core.dim_labels

where label = 'degen fat cats'),

sharx as (

select * from solana.core.dim_labels

where label = 'sharx by sharky.fi'),

squirrels as (

select * from solana.core.dim_labels

where label = 'liberty square: the sinister squirrel syndicate'),

table1 as (

select purchaser

from solana.core.fact_nft_sales

where mint in (select address from sharx)

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 sharx)

group by 1)