case

when amount between 0 and 15 then 'a. 0-15'

when amount between 16 and 100 then 'b. 16-100'

when amount between 101 and 500 then 'c. 101-500'

when amount between 501 and 1500 then 'd. 501-1500'

when amount > 1500 then 'e. greater than 1500'

end as payout,

from algorand.payment_transaction

where block_timestamp::date > '2022-03-30'

and sender='57QZ4S7YHTWPRAM3DQ2MLNSVLAQB7DTK4D7SUNRIEFMRGOU7DMYFGF55BY'

and try_base64_decode_string(tx_message:txn:note) like '%af/gov1:j{"rewardsPrd":2%'

group by 1 having payout is not null