with payouts as (
SELECT
receiver,
amount
FROM algorand.payment_transaction
WHERE block_timestamp::date > '2022-04-04'
AND try_base64_decode_string(tx_message:txn:note::string) LIKE '%af/gov1:j{"rewardsPrd":2%'
AND sender = '57QZ4S7YHTWPRAM3DQ2MLNSVLAQB7DTK4D7SUNRIEFMRGOU7DMYFGF55BY'
)
SELECT
CASE
WHEN amount BETWEEN 0 AND 5 THEN '1. 0-5'
WHEN amount BETWEEN 5 AND 10 THEN '2. 5-10'
WHEN amount BETWEEN 10 AND 50 THEN '3. 10-50'
WHEN amount BETWEEN 50 AND 100 THEN '4. 50-100'
WHEN amount BETWEEN 100 AND 500 THEN '5. 100-500'
WHEN amount BETWEEN 500 AND 1000 THEN '6.500-1000'
WHEN amount > 1000 THEN '> 1000'
END AS gp,
COUNT(receiver) as gp_count
FROM payouts
GROUP BY 1