with txs as (select p.block_timestamp, receiver, amount, balance from algorand.payment_transaction p inner join algorand.account a on p.receiver = a.address where sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE' and amount <= 10000), receiver as (select receiver, count(amount) as num_payments, sum(amount) as amount_received, amount_received/num_payments as avg, avg(balance) as balance from txs group by receiver) select *, (case when balance < 1 then '1 or less' when balance >= 1 and balance < 5 then '1 and 5' when balance >= 5 and balance < 10 then '5 and 10' when balance >= 10 and balance < 100 then '10 and 100' when balance >= 100 and balance < 1000 then '100 and 1000' when balance >= 1000 then '1000+' end) as balance_dist, (case when amount_received < 1 then '1 or less' when amount_received >= 1 and amount_received < 5 then '1 and 5' when amount_received >= 5 and amount_received < 10 then '5 and 10' when amount_received >= 10 and amount_received < 100 then '10 and 100' when amount_received >= 100 and amount_received < 1000 then '100 and 1000' when amount_received >= 1000 then '1000+' end) as amount_dist, 1 as count, (case when balance = 0 then 100 when amount_received*100/balance > 100 then 100 else amount_received*100/balance end) as precentage_received, (case when precentage_received = 0 then '0%' when precentage_received > 0 and precentage_received <= 1 then '0% - 1%' when precentage_received > 1 and precentage_received <= 10 then '1% - 10%' when precentage_received > 10 and precentage_received <= 50 then '10% - 50%' when precentage_received > 50 and precentage_received <= 75 then '50% - 75%' when precentage_received > 75 and precentage_received <= 85 then '75% - 85%' when precentage_received > 85 and precentage_received <= 95 then '85% - 95%' when precentage_received > 95 and precentage_received < 100 then '95% - 100%(excluding 100%)' when precentage_received = 100 then '100%' end) as percentage_dist from receiver

Flipside Algorand Wallet Behavior