case

when TOKEN_METADATA:Clothing in ('NB-Ape Green','NB-Ape Yellow','NB-Ape Red','Bowling Shirt','Cheerleader') then 'Sport-related cloth'

when TOKEN_METADATA:Clothing in ('Police Uniform','Leather Jacket','Jungle Explorer','Denim Vest','Pilots Jacket') then 'Army-type cloth'

else 'Other cloth'

end as gp,

CASE

WHEN (SALES_AMOUNT) <= 30 THEN 'a.below 30 SOL'

WHEN (SALES_AMOUNT) > 30 and (SALES_AMOUNT) <=50 THEN 'b.30-50 SOL'

WHEN (SALES_AMOUNT) > 50 and (SALES_AMOUNT) <=100 THEN 'c.50-100 SOL'

WHEN (SALES_AMOUNT) > 100 THEN 'd.above 100 SOL'

END as buckets,

count(distinct tx_id) as sale_no,

count(distinct purchaser) as buyer_no

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 '%Degen Apes%'

group by 1,2 having gp is not null