with transfer_out as ( select from_address as address, -1 * sum(rune_amount_usd) as balance from thorchain.transfers group by address ), transfer_in as ( select to_address as address, sum(rune_amount_usd) as balance from thorchain.transfers group by address ), balance as ( select address, sum(balance) as balance from ( ( select * from transfer_out ) union ( select * from transfer_in ) ) group by address ) ( select COUNT_IF(balance >= pow(10, 9)) as no_of_addresses, 'balance >= 1B $USD' as type from balance ) union ( select COUNT_IF( balance >= 500 * pow(10, 6) and balance < pow(10, 9) ) as no_of_addresses, '500M $USD <= balance < 1B $USD' as type from balance ) union ( select COUNT_IF( balance >= 100 * pow(10, 6) and balance < 500 * pow(10, 6) ) as no_of_addresses, '100M $USD <= balance < 500M $USD' as type from balance ) union ( select COUNT_IF( balance >= 50 * pow(10, 6) and balance < 100 * pow(10, 6) ) as no_of_addresses, '50M $USD <= balance < 100M $USD' as type from balance ) union ( select COUNT_IF( balance >= 1 * pow(10, 6) and balance < 50 * pow(10, 6) ) as no_of_addresses, '1M $USD <= balance < 50M $USD' as type from balance ) union ( select COUNT_IF( balance >= 500 * pow(10, 3) and balance < 1 * pow(10, 6) ) as no_of_addresses, '500K $USD <= balance < 1M $USD' as type from balance ) union ( select COUNT_IF( balance >= 1 and balance < 500 * pow(10, 3) ) as no_of_addresses, 'balance < 500K $USD' as type from balance )

THOR-18. [Easy] Wealth distribution