/*18. [Easy] Wealth distribution*/ WITH toAddress AS ( SELECT to_address AS address, SUM(rune_amount_usd) AS to_amount_usd FROM thorchain.transfers GROUP BY 1 ORDER BY 1 DESC ), fromAddress AS ( SELECT from_address AS address, SUM(rune_amount_usd) AS from_amount_usd FROM thorchain.transfers GROUP BY 1 ORDER BY 1 DESC ), totalAmount AS ( SELECT coalesce(fromAddress.address, toAddress.address) AS address, round(to_amount_usd - from_amount_usd,2) AS amount_usd FROM fromAddress JOIN toAddress ON fromAddress.address = toAddress.address ORDER BY 2 DESC ) SELECT CASE WHEN amount_usd < 10 THEN 'a. Less than 10 USD' WHEN amount_usd >= 10 AND amount_usd < 100 THEN 'b. between 10 and 100 USD' WHEN amount_usd >= 100 AND amount_usd < 500 THEN 'c. between 100 and 500 USD' WHEN amount_usd >= 500 AND amount_usd < 1000 THEN 'd. between 500 and 1,000 USD' WHEN amount_usd >= 1000 AND amount_usd < 5000 THEN 'e. between 1,000 and 5,000 USD' WHEN amount_usd >= 5000 AND amount_usd < 10000 THEN 'f. between 5,000 and 10,000 USD' WHEN amount_usd >= 10000 AND amount_usd < 50000 THEN 'g. between 10,000 and 50,000 USD' WHEN amount_usd >= 50000 AND amount_usd < 100000 THEN 'h. between 50,000 and 100,000 USD' WHEN amount_usd >= 100000 AND amount_usd < 500000 THEN 'i. between 100,000 and 500,000 USD' WHEN amount_usd >= 500000 AND amount_usd < 1000000 THEN 'j. between 500,000 and 1,000,000 USD' WHEN amount_usd >= 1000000 AND amount_usd < 5000000 THEN 'k. between 1,000,000 and 5,000,000 USD' WHEN amount_usd >= 5000000 AND amount_usd < 10000000 THEN 'l. between 5,000,000 and 10,000,000 USD' WHEN amount_usd >= 10000000 THEN 'm. above 10,000,000 USD' END AS usdBlock, count(address) FROM totalAmount GROUP BY usdBlock ORDER BY usdBlock

ThorChain wealth distribution