/*SELECT ADDRESS , 100* REWARDS_TOTAL/ ( SELECT sum(REWARDS_TOTAL) from algorand.account ) FROM algorand.account
where
-- MAX(REWARDS_TOTAL) = 25358653.059435
SELECT COUNT(*) FROM algorand.account
WHERE account_closed = 'FALSE'
*/
select concat(bucket * 100000, '-', (bucket * 100000 - 1) + 100000) as prange, count(REWARDS_TOTAL)
from
(select *, floor(REWARDS_TOTAL/100000) as bucket
from algorand.account
)
group by bucket
order by bucket