where block_timestamp::date > '2022-03-30'

and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%')

,ALGO_rewards as ( select sum(amount) from algorand.payment_transaction

where block_timestamp::date > '2022-03-30'

and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%')

,How_much_time as (select TIMEDIFF(minute, min(block_timestamp), max(block_timestamp)) as TIMEDIFF from algorand.payment_transaction

where block_timestamp::date > '2022-03-30' and

try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%')

,What_wallet_how_much as (select top 1 receiver,amount from algorand.payment_transaction

where block_timestamp::date > '2022-03-30' and

try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%'

order by amount DESC )

select * from What_wallet_how_much