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'),

maintable as (

select 'Degen Fat Cats' as fox_type,

seller,

count (distinct tx_id) as Sales_Count,

count (distinct purchaser) as Purchasers_Count,

count (distinct seller) as Sellers_Count,

count (distinct mint) as Tokens_Count,

sum (sales_amount) as Total_Sale_Volume,

avg (sales_amount) as Average_Sale_Price,

median (sales_amount) as Median_Sale_Price,

min (sales_amount) as Minimum_Sale_Price,

max (sales_amount) as Maximum_Sale_Price

from solana.core.fact_nft_sales

where mint in (select address from degencats)

and succeeded = 'TRUE'

group by 1,2

union ALL

select 'Sharx' as fox_type,

seller,

count (distinct tx_id) as Sales_Count,

count (distinct purchaser) as Purchasers_Count,

count (distinct seller) as Sellers_Count,