with withdrawal as (SELECT * from (SELECT tx_signer as addr, sum(deposit)/pow(10,24)*(-1) as amt, count(DISTINCT tx_hash) as total_txs from mdao_near.transfers where tx_signer != 'sweat_welcome.near' GROUP by 1 ) where total_txs > 2 ), deposits as (SELECT * from (SELECT tx_receiver as addr, sum(deposit)/pow(10,24) as amt, count(DISTINCT tx_hash) as total_txs from mdao_near.transfers where tx_signer != 'sweat_welcome.near' GROUP by 1) where total_txs > 2 ) SELECT distribution,distribution_txs, count(DISTINCT addr) as total_addresses from (SELECT addr, sum(amt) as net_balance,sum(total_txs) as net_txs, case when net_balance =0 then 'zero NEAR' when net_balance < 1 then 'a-less than 1 NEAR' when net_balance >= pow(10,0) and net_balance < pow(10,1) then 'b- 1-10 NEAR' when net_balance >= pow(10,1) and net_balance < pow(10,2) then 'c- 10-100 NEAR' when net_balance >= pow(10,2) and net_balance < pow(10,3) then 'd- 100-1k NEAR' when net_balance >= pow(10,3) and net_balance < pow(10,4) then 'e- 1k-10k NEAR' when net_balance >= pow(10,4) and net_balance < pow(10,5) then 'f- 10k-100k NEAR' when net_balance >= pow(10,5) and net_balance < pow(10,6) then 'g- 100k-1M NEAR' when net_balance >= pow(10,6) and net_balance < pow(10,7) then 'h- 1M-10M NEAR' when net_balance >= pow(10,7) then 'i- 10M+ NEAR' end as distribution, case when net_txs >= pow(10,0) and net_txs < 3 then 'a- 1-3 txs' when net_txs >= 3 and net_txs < 6 then 'b- 3-5 txs' when net_txs >= 6 and net_txs < 11 then 'c- 6-10 txs' when net_txs >= 11 and net_txs < 16 then 'd- 10-15 txs' when net_txs >= 16 and net_txs < 31 then 'e- 16-30 txs' when net_txs >= 31 and net_txs < 51 then 'f- 31-50 txs' when net_txs >= 51 and net_txs < 101 then 'g- 51-100 txs' when net_txs >= 101 then 'h- 100+ txs' end as distribution_txs from (SELECT * from deposits UNION ALL SELECT * FROM withdrawal) GROUP by 1 ) GROUP by 1 , 2 limit 100

NEAR Distribution