COUNT(program_id) AS uni_count, program_id,

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 to_date(block_timestamp) >= '2022-01-01'

GROUP BY 2

ORDER BY 1

DESC

LIMIT 5