SELECT DISTINCT DEPOSITOR AS user FROM ethereum.maker.ez_deposits

UNION ALL

SELECT DISTINCT ORIGIN_FROM_ADDRESS AS user FROM ethereum.maker.ez_delegations

UNION ALL

SELECT DISTINCT VOTER AS user FROM ethereum.maker.ez_governance_votes

UNION ALL

SELECT DISTINCT BORROWER AS user FROM ethereum.maker.ez_flash_loans

UNION ALL

SELECT DISTINCT LIQUIDATED_WALLET AS user FROM ethereum.maker.ez_liquidations

UNION ALL

SELECT DISTINCT PAYER AS user FROM ethereum.maker.ez_repayments

UNION ALL

SELECT DISTINCT CREATOR AS user FROM ethereum.maker.ez_vault_creation

UNION ALL

SELECT DISTINCT WITHDRAWER AS user FROM ethereum.maker.ez_withdrawals

),

balance AS (

SELECT

USER_ADDRESS,

CURRENT_BAL AS ETH_balance

FROM ethereum.core.ez_current_balances

WHERE USER_ADDRESS IN (SELECT user FROM users) AND TOKEN_NAME = 'Native Ether'

CASE

WHEN ETH_balance <= 1 THEN 'shrimp'

WHEN ETH_balance <= 100 THEN 'Fish'

WHEN ETH_balance <= 1000 THEN 'shark'

WHEN ETH_balance <= 10000 THEN 'whale'

ELSE 'humpback'

END AS user_balance,

COUNT(*) AS "Number of users"

FROM balance

GROUP BY user_balance;