CASE

WHEN program_id ='JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' THEN 'BPF Upgradeable Loader'

WHEN program_id ='9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' THEN 'Serum DEX V3'

WHEN program_id ='675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8' THEN 'Raydium Liquidity Pool V4'

WHEN program_id ='mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68' THEN 'Mango Markets V3'

WHEN program_id ='11111111111111111111111111111111' THEN 'Wrapped Sol'

END AS program_id

FROM SOLANA.core.fact_events

WHERE

( program_id = '11111111111111111111111111111111'

OR program_id = '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin'

OR program_id = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo'

OR program_id = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'

OR program_id = '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8') AND uni_date >= '2022-01-01'

GROUP BY 2,3