when program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA' then 'token program'

when program_id = '675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8' then 'Raydium Liquidity Pool V4'

when program_id = '11111111111111111111111111111111' then 'System Program'

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

when program_id = '9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin' then 'Serum DEX V3'

else 'None'

end as program_name,

count(tx_id) as count_tx_id

from solana.core.fact_events

where block_timestamp >= '2022-01-01'

and succeeded = 'TRUE'

group by 1

order by 3 desc