select * from solana.core.dim_labels

where label = 'famous fox federation'),

transdimensionalt as (

select * from solana.core.dim_labels

where label = 'transdimensional fox federation'),

maintable as (

select 'Famous Fox Federation' 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 famoust)

and succeeded = 'TRUE'

group by 1,2

union ALL

select 'Transdimensional Fox Federation' 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,