select receiver as wallet_paid,

sum(amount) as paid_ALGO,

balance,

case

when balance != 0 then paid_ALGO/balance*100

when balance = 0 then 0

end as perc

from algorand.payment_transaction pt

inner join algorand.account a

on pt.receiver = a.address

where sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE'

and amount < 10000

group by 1, 3

order by 2 desc

select count (wallet_paid),

case

when perc = 0 or perc >= 1000 then '01. Real Big Spender (+1000)'

when perc >= 500 and perc < 1000 then '02. Bird in Hand (500-1000)'

when perc >= 100 and perc < 500 then '03. Keep it Safe (100-500)'

when perc >= 50 and perc < 100 then '04. Icing in the cake (50-100)'

when perc > 0 and perc < 50 then '05. Side business (0-50)'

end as class

from PERC

group by 2

order by 2