case

when balance > 1000 then '01. Dinosaur (+1000)'

when balance >= 100 and balance < 1000 then '02. Elephant (100-1000)'

when balance >= 10 and balance < 100 then '03. Horse (10-100)'

when balance >= 1 and balance < 10 then '04. Dog (1-10)'

when balance >= 0 and balance < 1 then '05. Snail (0-1)'

end as class

from algorand.payment_transaction pt

inner join algorand.account a

on pt.receiver = a.address

where sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE'

and amount < 10000

group by 2

order by 1 desc