with degencats as (
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'),
table11 as (
select purchaser
from solana.core.fact_nft_sales
where mint in (select address from degencats)
and succeeded = 'TRUE'),
table22 as (select count (distinct purchaser) as Buyers_Count from table11),
table33 as (
select t1.purchaser,
t2.mint,
label
from table11 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),
table44 as (
select label,
count (distinct purchaser) as Non_Buyers_Count
from table33
where mint not in (select address from degencats)
group by 1),
table55 as (