select *,

try_base64_decode_string(tx_message:txn:note::string) as message,

tx_message:txn:apid as app_id

from algorand.application_call_transaction

where try_base64_decode_string(tx_message:txn:note::string) in ('Market: mt', 'Market: rcu')

and app_id='465814222'

and block_timestamp>= CURRENT_DATE-90)

date_trunc('day',block_timestamp) as dt,

case when message = 'Market: mt' then 'Mint'

when message = 'Market: rcu' then 'Burn'

end as actions,

count(distinct tx_id) as no_mint

from t2

group by 1,2 having actions is not null