with main AS ( select CASE WHEN amount <= 20 THEN '01 [0,20]' WHEN amount > 20 AND amount <= 40 THEN '02 (20,40]' WHEN amount > 40 AND amount <= 60 THEN '03 (40,60]' WHEN amount > 60 AND amount <= 80 THEN '04 (60,80]' WHEN amount > 80 AND amount <= 100 THEN '05 (80,100]' WHEN amount > 100 AND amount <= 120 THEN '06 (100,120]' WHEN amount > 120 AND amount <= 140 THEN '07 (120,140]' WHEN amount > 140 AND amount <= 160 THEN '08 (140,160]' WHEN amount > 160 AND amount <= 180 THEN '09 (160,180]' WHEN amount > 180 AND amount <= 200 THEN '10 (180,200]' WHEN amount > 200 AND amount <= 220 THEN '11 (200,220]' WHEN amount > 220 AND amount <= 240 THEN '12 (220,240]' WHEN amount > 240 AND amount <= 260 THEN '13 (240,260]' WHEN amount > 260 AND amount <= 280 THEN '14 (260,280]' WHEN amount > 280 AND amount <= 300 THEN '15 (280,300]' WHEN amount > 300 AND amount <= 320 THEN '16 (300,320]' WHEN amount > 320 AND amount <= 340 THEN '17 (320,340]' WHEN amount > 340 AND amount <= 360 THEN '18 (340,360]' WHEN amount > 360 AND amount <= 380 THEN '19 (360,380]' WHEN amount > 380 AND amount <= 400 THEN '20 (380,400]' WHEN amount > 400 AND amount <= 420 THEN '21 (400,420]' WHEN amount > 420 AND amount <= 440 THEN '22 (420,440]' WHEN amount > 440 AND amount <= 460 THEN '23 (440,460]' WHEN amount > 460 AND amount <= 480 THEN '24 (460,480]' WHEN amount > 480 AND amount <= 500 THEN '25 (480,500]' WHEN amount > 500 AND amount <= 520 THEN '26 (500,520]' WHEN amount > 520 AND amount <= 540 THEN '27 (520,540]' WHEN amount > 540 AND amount <= 560 THEN '28 (540,560]' WHEN amount > 560 AND amount <= 580 THEN '29 (560,580]' WHEN amount > 580 AND amount <= 600 THEN '30 (580,600]' WHEN amount > 600 AND amount <= 620 THEN '31 (600,620]' WHEN amount > 620 AND amount <= 640 THEN '32 (620,640]' WHEN amount > 640 AND amount <= 660 THEN '33 (640,660]' WHEN amount > 660 AND amount <= 680 THEN '34 (660,680]' WHEN amount > 680 AND amount <= 700 THEN '35 (680,700]' WHEN amount > 700 AND amount <= 720 THEN '36 (700,720]' WHEN amount > 720 AND amount <= 740 THEN '37 (720,740]' WHEN amount > 740 AND amount <= 760 THEN '38 (740,760]' WHEN amount > 760 AND amount <= 780 THEN '39 (760,780]' WHEN amount > 780 AND amount <= 800 THEN '40 (780,800]' WHEN amount > 800 AND amount <= 820 THEN '41 (800,820]' WHEN amount > 820 AND amount <= 840 THEN '42 (820,840]' WHEN amount > 840 AND amount <= 860 THEN '43 (840,860]' WHEN amount > 860 AND amount <= 880 THEN '44 (860,880]' WHEN amount > 880 AND amount <= 900 THEN '45 (880,900]' WHEN amount > 900 AND amount <= 920 THEN '46 (900,920]' WHEN amount > 920 AND amount <= 940 THEN '47 (920,940]' WHEN amount > 940 AND amount <= 960 THEN '48 (940,960]' WHEN amount > 960 AND amount <= 980 THEN '49 (960,980]' WHEN amount > 980 AND amount <= 1000 THEN '50 (980,1000]' WHEN amount > 1000 THEN '51 >1000' END AS amount_bucket , count(*) AS transactions from algorand.payment_transaction where block_timestamp::date > '2022-03-30' and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%' GROUP BY 1 ORDER BY 1 ) SELECT * , sum(transactions) OVER (ORDER BY amount_bucket)/sum(transactions) OVER () AS cum_percent_sum_transactions FROM main ORDER BY amount_bucket -- select * -- from algorand.payment_transaction -- where block_timestamp::date > '2022-03-30' and try_base64_decode_string(tx_message:txn:note::string) like '%af/gov1:j{"rewardsPrd":2%' -- AND receiver = 'WC6M5SRAF5NTTODMW5U5CLOFZNEBRLVARXXM4LSI36BVLIIJT4IIMCAYZ4'

Query	Creator	Created
Untitled Query	miguelblaise	Apr 14, 2022
Time from First to Last Payment	miguelblaise	Apr 14, 2022
Payout Distribution	miguelblaise	Apr 14, 2022
Untitled Query	miguelblaise	Apr 14, 2022
Total Reward Payments	miguelblaise	Apr 14, 2022
Total Payment Amount	miguelblaise	Apr 14, 2022
Largest Payout	miguelblaise	Apr 14, 2022

miguelblaise