SELECT

BORROWER_ADDRESS,

sum(BORROWED_TOKENS) as vol_token,

sum(BORROWED_USD) as vol_usd

FROM ethereum.aave.ez_borrows

WHERE symbol ilike ('SNX')

AND AAVE_VERSION = 'Aave V2'

GROUP by 1

CASE

WHEN vol_token < 10 THEN 'a. < 10 SNX'

WHEN vol_token BETWEEN 10 and 50 THEN 'b. 10 ~ 50 SNX'

WHEN vol_token BETWEEN 50 and 100 THEN 'c. 50 ~ 100 SNX'

WHEN vol_token BETWEEN 100 and 500 THEN 'd. 100 ~ 500 SNX'

WHEN vol_token BETWEEN 500 and 1000 THEN 'e. 500 ~ 1K SNX'

WHEN vol_token BETWEEN 1000 and 5000 THEN 'f. 1 ~ 5K SNX'

WHEN vol_token BETWEEN 5000 and 10000 THEN 'g. 5 ~ 10K SNX'

WHEN vol_token > 10000 THEN 'h. > 10K SNX'

END as Token_distribute,

CASE

WHEN vol_usd < 10 THEN 'a. < $10'

WHEN vol_usd BETWEEN 10 and 50 THEN 'b. 10 ~ $50'

WHEN vol_usd BETWEEN 50 and 100 THEN 'c. 50 ~ $100'

WHEN vol_usd BETWEEN 100 and 500 THEN 'd. 100 ~ $500'

WHEN vol_usd BETWEEN 500 and 1000 THEN 'e. 500 ~ $1K'

WHEN vol_usd BETWEEN 1000 and 5000 THEN 'f. 1 ~ $5K'

WHEN vol_usd BETWEEN 5000 and 10000 THEN 'g. 5 ~ $10K'

WHEN vol_usd > 10000 THEN 'h. > $10K'

END as usd_distribute,

COUNT(DISTINCT BORROWER_ADDRESS) as borrower_cnt

FROM tb

GROUP by 1,2

ORDER by 3 DESC