SELECT

CASE

WHEN ORIGIN_FUNCTION_SIGNATURE = '0x6e553f65' THEN 'Minting(stakes)'

WHEN ORIGIN_FUNCTION_SIGNATURE = '0xba087652' THEN 'Burning(Unstakes)'

END AS transaction_type,

COUNT(*) AS transaction_count

FROM monad.testnet.fact_event_logs

WHERE ORIGIN_FUNCTION_SIGNATURE IN ('0x6e553f65', '0xba087652')

AND TX_SUCCEEDED = 'TRUE'

AND CONTRACT_ADDRESS = '0x3a98250f98dd388c211206983453837c8365bdc1'

GROUP BY ORIGIN_FUNCTION_SIGNATURE

SELECT

transaction_type,

transaction_count

FROM tx_counts

ORDER BY transaction_type;