SELECT

CASE

WHEN LOWER(DESCRIPTION) LIKE '%trading%'

OR LOWER(NAME) LIKE '%trader%'

OR LOWER(DESCRIPTION) LIKE '%arbitrage%'

THEN 'Trading & Arbitrage'

WHEN LOWER(DESCRIPTION) LIKE '%liquidity%'

OR LOWER(DESCRIPTION) LIKE '%liquidation%'

THEN 'Liquidity Management'

WHEN LOWER(DESCRIPTION) LIKE '%prediction market%'

OR LOWER(DESCRIPTION) LIKE '%options trading%'

THEN 'Prediction Markets & Options'

WHEN LOWER(DESCRIPTION) LIKE '%dao%'

OR LOWER(DESCRIPTION) LIKE '%multi-agent%'

OR LOWER(DESCRIPTION) LIKE '%governance%'

THEN 'DAO & Multi-Agent Systems'

WHEN LOWER(DESCRIPTION) LIKE '%ai%'

OR LOWER(DESCRIPTION) LIKE '%rag-based%'

OR LOWER(DESCRIPTION) LIKE '%machine learning%'

OR LOWER(DESCRIPTION) LIKE '%chatgpt%'

OR LOWER(DESCRIPTION) LIKE '%short films%'

THEN 'AI & Machine Learning'

WHEN LOWER(DESCRIPTION) LIKE '%rpc%'

OR LOWER(DESCRIPTION) LIKE '%notification%'

OR LOWER(DESCRIPTION) LIKE '%gateway%'

OR LOWER(DESCRIPTION) LIKE '%abci%'

OR LOWER(NAME) LIKE '%hello_world%'

THEN 'Infrastructure & Tooling'

WHEN LOWER(DESCRIPTION) LIKE '%nft%'

OR LOWER(DESCRIPTION) LIKE '%meme%'

OR LOWER(DESCRIPTION) LIKE '%twitter%'

OR LOWER(DESCRIPTION) LIKE '%farcaster%'

OR LOWER(NAME) LIKE '%memeooorr%'

THEN 'NFT & Social Media'

WHEN LOWER(DESCRIPTION) LIKE '%prediction%'