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

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

WHEN program_id = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' THEN 'Jupiter Aggregator'

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

WHEN program_id = '11111111111111111111111111111111' THEN 'System Program'

end as program_name, *

from (select program_id, min(block_timestamp) as first_use, count(*) as total_calls from

(select * from solana.core.fact_events

where block_timestamp > '2022-01-01')

GROUP by 1

ORDER by 3 desc )

where program_name is not NULL