case

when amount > 0 and amount <= 10 then '0-10 ALGO'

when amount > 10 and amount <= 100 then '10-100 ALGO'

when amount > 100 and amount <= 1000 then '100-1k ALGO'

when amount > 1000 and amount <= 10000 then '1k-10k ALGO'

when amount > 10000 then '+10k ALGO'

end as payment_size,

case

when amount > 0 and amount <= 10 then 1

when amount > 10 and amount <= 100 then 2

when amount > 100 and amount <= 1000 then 3

when amount > 1000 and amount <= 10000 then 4

when amount > 10000 then 5

end as ordered,

count(tx_id) as number_transactions,

sum(amount) as total_value_transacted

from algorand.payment_transaction

where fecha >= '2022-01-01'

and amount > 0

group by 1, 2, 3

order by 3 desc