case

when instructions[0]:programId = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc' then 'Kamino Program'

when instructions[0]:programId = 'JUP3c2Uh3WA4Ng34tw6kPd2G4C5BB21Xo36Je1s32Ph' then 'jupiter aggregator v3'

when instructions[0]:programId = 'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc' then 'Orca'

when instructions[0]:programId = 'JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB' then 'jupiter aggregator v4'

when instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T' then 'Hubble Protocol'

when instructions[0]:programId = '5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h' then 'Raydium'

when instructions[0]:programId = 'TLPv2tuSVvn3fSk8RgW3yPddkp5oFivzZV3rA9hQxtX' then 'Tulip Protocol' else 'OTHER_PLATFORMS' end as PLATFORM,

count (distinct tx_id) as TX_Count,

count (distinct signers[0]) as Users_Count

from solana.core.fact_transactions t1 full outer join solana.core.dim_labels t2 on t1.instructions[0]:programId = t2.address

where (inner_instructions[1]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

or inner_instructions[0]:instructions[0]:parsed:info:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

or pre_token_balances[0]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'

or pre_token_balances[1]:mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX')

and succeeded = 'TRUE'

and block_timestamp >= CURRENT_DATE - 60

and instructions[0]:programId != 'ComputeBudget111111111111111111111111111111'

GROUP BY 1,2