select
date_trunc('day',block_timestamp) as block_day,
try_base64_decode_string(tx_message:txn:apaa[0]::string) as note,
count(note)
from algorand.application_call_transaction
where
block_timestamp >= '2022-01-01'
and app_id = 233725850
and note is not null
group BY
block_day,note
order by
block_day