WITH a AS ( SELECT COUNT(CASE WHEN balance >= 1 and balance < 10 THEN 1 ELSE NULL END) AS num FROM flipside_prod_db.algorand.account JOIN flipside_prod_db.algorand.block ON block_id = created_at WHERE block_timestamp >= '2022-05-01' AND block_timestamp < '2022-06-01' ), b AS ( SELECT COUNT(CASE WHEN balance >= 10 AND balance < 100 THEN 1 ELSE NULL END) AS num FROM flipside_prod_db.algorand.account JOIN flipside_prod_db.algorand.block ON block_id = created_at WHERE block_timestamp >= '2022-05-01' AND block_timestamp < '2022-06-01' ), c AS ( SELECT COUNT(CASE WHEN balance >= 100 AND balance < 1000 THEN 1 ELSE NULL END) AS num FROM flipside_prod_db.algorand.account JOIN flipside_prod_db.algorand.block ON block_id = created_at WHERE block_timestamp >= '2022-05-01' AND block_timestamp < '2022-06-01' ), d AS ( SELECT COUNT(CASE WHEN balance >= 1000 AND balance < 10000 THEN 1 ELSE NULL END) AS num FROM flipside_prod_db.algorand.account JOIN flipside_prod_db.algorand.block ON block_id = created_at WHERE block_timestamp >= '2022-05-01' AND block_timestamp < '2022-06-01' ), e AS ( SELECT COUNT(CASE WHEN balance >= 10000 AND balance < 100000 THEN 1 ELSE NULL END) AS num FROM flipside_prod_db.algorand.account JOIN flipside_prod_db.algorand.block ON block_id = created_at WHERE block_timestamp >= '2022-05-01' AND block_timestamp < '2022-06-01' ), f AS ( SELECT COUNT(CASE WHEN balance >= 100000 THEN 1 ELSE NULL END) AS num FROM flipside_prod_db.algorand.account JOIN flipside_prod_db.algorand.block ON block_id = created_at WHERE block_timestamp >= '2022-05-01' AND block_timestamp < '2022-06-01' ) select num, '1-10 ALGO' as type, 1 as rank from a union all select num, '10-100 ALGO' as type, 2 as rank from b union all select num, '100-1,000 ALGO' as type, 3 as rank from c union all select num, '1,000-10,000 ALGO' as type, 4 as rank from d union all select num, '10,000-100,000 ALGO' as type, 5 as rank from e union all select num, '>= 100,000 ALGO' as type, 6 as rank from f

New Wallets in May