with users AS (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,

max(LAST_RECORDED_PRICE) AS Time

from ethereum.core.ez_current_balances inner join users on USER_ADDRESS=user

where TOKEN_NAME='Native Ether'

group by 1,2)

case

when ETH_balance <= 1 then 'shrimp'

when ETH_balance > 1 and ETH_balance <= 100 then 'Fish'

when ETH_balance > 100 and ETH_balance <= 1000 then 'shark'

when ETH_balance > 1000 and ETH_balance <= 10000 then 'whale'

when ETH_balance > 10000 then 'humpback'

end AS user_balance,

count(user_balance) AS "Number of users"

from balance group by 1