select

case

when TOKEN_METADATA:Clothing in ('Golf','Fishing Waders','Stadium','La Pulga Kit','Mamba','The King Kit','Beast Mode') then 'Sport-related cloth'

when TOKEN_METADATA:Clothing in ('Round Jacket', 'White Tank', 'Desert Storm', 'Camo', 'Bullet Proof', 'Squid') then 'Army-type cloth'

else 'Other cloth'

end as gp,

count(TX_ID) as no_sale,

count(distinct purchaser) as no_buyer,

sum(sales_amount) as volume,

avg(sales_amount) as average_price

from solana.core.fact_nft_sales s left outer join solana.core.dim_nft_metadata b on s.mint=b.MINT

where SUCCEEDED='TRUE' and PROJECT_NAME ilike '%Catalina Whale%'

group by 1 having gp is not null