with burntable as ( select count (distinct tx_id) as Burn_Count

from solana.core.fact_events

where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and inner_instruction:instructions[0]:parsed:type = 'burn'

and succeeded = 'TRUE'),

MintTable as ( select count (distinct tx_id) as Mint_Count

from solana.core.fact_events

where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and inner_instruction:instructions[0]:parsed:type = 'mintTo'

and succeeded = 'TRUE'),

transfertable as ( select count (distinct tx_id) as Transfers_Count

from solana.core.fact_events

where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and inner_instruction:instructions[0]:parsed:type = 'transfer'

and succeeded = 'TRUE'),

alltable as ( select count (distinct tx_id) as All_Count

from solana.core.fact_events

where program_id = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and succeeded = 'TRUE')

select (Burn_Count/All_Count) * 100 as Burn_Ratio,

(Mint_Count/All_Count) * 100 as Mint_Ratio,

(Transfers_Count/All_Count) * 100 as Transfers_Ratio

from burntable join minttable join alltable join transfertable