case

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

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

when program_id = '11111111111111111111111111111111' then 'Wrapped SOL (SOL)'

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

when program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA' then 'BPF Loader 2'

when program_id = '4FuHh13dadkVJQeDFdtQg8vMKRPxVZJLU7dEXy61Y5Bn' then 'BPF Upgradeable Loader'

when program_id = 'SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f' then 'SwitchBoardV2'

when program_id = '9723cqpsBZN1sAP9QH9FoQBD93wgxRVqyfk7XPiEUU6k' then 'owner:BPF Upgradeable Loader'

when program_id = '7T5zyFsWSCqXYhrowHqY6jcUvwZkPJ3xiEu5mgzU7VWt' then 'BPFLoaderUpgradeab1e11111111111111111111111'

when program_id = 'GCQ2KPaxKeweMdHcJtfdFd88o1mQvntA1oPSBkSfJwQp' then 'owner:BPFLoaderUpgradeab1e11111111111111111111111'

else null end as program_id,

count(tx_id) as trxs

from solana.core.fact_events

where block_timestamp>'2022-01-01'

and succeeded='true'

group by 1

order by 2 desc

limit 10