WITH bl_id AS ( SELECT min(block_id) FROM terra.blocks WHERE to_date(block_timestamp)=dateadd(day,-91,CURRENT_DATE()) ), trans AS ( SELECT tx_from[0] wallet FROM terra.transactions WHERE block_id>=(SELECT * FROM bl_id) ), final as ( SELECT tx_from[0] wallets FROM terra.transactions WHERE tx_from[0] IN (SELECT * FROM trans) GROUP BY 1 HAVING(min(block_id)>=(SELECT * FROM bl_id)) ), tx_count1 AS( SELECT tx_from[0] wallets, COUNT (tx_id) tx_count FROM terra.transactions WHERE tx_from[0] IN (SELECT * FROM final) GROUP BY tx_from[0] HAVING(tx_count<=10) ), tx_count2 AS( SELECT tx_from[0] wallets, COUNT (tx_id) tx_count FROM terra.transactions WHERE tx_from[0] IN (SELECT * FROM final) GROUP BY tx_from[0] HAVING(tx_count<=20 AND tx_count>10) ), tx_count3 AS( SELECT tx_from[0] wallets, COUNT (tx_id) tx_count FROM terra.transactions WHERE tx_from[0] IN (SELECT * FROM final) GROUP BY tx_from[0] HAVING(tx_count<=40 AND tx_count>20) ), tx_count4 AS( SELECT tx_from[0] wallets, COUNT (tx_id) tx_count FROM terra.transactions WHERE tx_from[0] IN (SELECT * FROM final) GROUP BY tx_from[0] HAVING(tx_count<=80 AND tx_count>40) ), tx_count5 AS( SELECT tx_from[0] wallets, COUNT (tx_id) tx_count FROM terra.transactions WHERE tx_from[0] IN (SELECT * FROM final) GROUP BY tx_from[0] HAVING(tx_count<=160 AND tx_count>80) ), tx_count6 AS( SELECT tx_from[0] wallets, COUNT (tx_id) tx_count FROM terra.transactions WHERE tx_from[0] IN (SELECT * FROM final) GROUP BY tx_from[0] HAVING(tx_count>160) ) SELECT 'tx_count<=10' AS Category,COUNT(wallets) AS number_of_wallets FROM tx_count1 UNION SELECT 'tx_count>10 & tx_count<=20' AS Category,COUNT(wallets) AS number_of_wallets FROM tx_count2 UNION SELECT 'tx_count>20 & tx_count<=40' AS Category,COUNT(wallets) AS number_of_wallets FROM tx_count3 UNION SELECT 'tx_count>40 & tx_count<=80' AS Category,COUNT(wallets) AS number_of_wallets FROM tx_count4 UNION SELECT 'tx_count>80 & tx_count<=160' AS Category,COUNT(wallets) AS number_of_wallets FROM tx_count5 UNION SELECT 'tx_count>160' AS Category,COUNT(wallets) AS number_of_wallets FROM tx_count6

Analyzing new wallet addresses on terra