(SELECT tx_signer as addr, sum(deposit)/pow(10,24)*(-1) as amt from mdao_near.transfers

GROUP by 1 ),

deposits as

(SELECT tx_receiver as addr, sum(deposit)/pow(10,24) as amt from mdao_near.transfers

GROUP by 1)

SELECT distribution, count(DISTINCT addr) as total_addresses, sum(net_balance) as net_wealth_in_category from

(SELECT addr, sum(amt) as net_balance,

case 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

from

(SELECT * from deposits

UNION ALL

SELECT * FROM withdrawal)

GROUP by 1 )

GROUP by 1

limit 100