with t1 as(select

tx_group_id

from algorand.payment_transaction

where RECEIVER='RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'

select

SENDER,

count(TX_GROUP_ID) as txn_rand,

sum(amount) as rand_ALGO

from algorand.payment_transaction

where tx_group_id in (select tx_group_id from t1)

and RECEIVER not in ('RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE')

group by sender

order by txn_rand desc

limit 10