SELECT

INITIATOR_ADDRESS,

SUM(FLASHLOAN_AMOUNT_USD) AS volume

FROM ethereum.aave.ez_flashloans

GROUP BY INITIATOR_ADDRESS

SELECT

CASE

WHEN volume < 10 THEN 'a Less than 10'

WHEN volume < 100 THEN 'b 10-100'

WHEN volume < 1000 THEN 'c 100-1,000'

WHEN volume < 10000 THEN 'd 1,000-10,000'

WHEN volume < 100000 THEN 'e 10,000-100,000'

WHEN volume < 1000000 THEN 'f 100,000-1,000,000'

WHEN volume < 10000000 THEN 'g 1,000,000-10,000,000'

ELSE 'h Over 10,000,000'

END AS order_of_magnitude,

COUNT(DISTINCT INITIATOR_ADDRESS) AS total_users,

sum(volume) as total_volume

FROM loan_users

WHERE volume < 100000000000

GROUP BY order_of_magnitude

ORDER BY

CASE

WHEN order_of_magnitude = 'Less than 10' THEN 1

WHEN order_of_magnitude = '10-100' THEN 2

WHEN order_of_magnitude = '100-1,000' THEN 3

WHEN order_of_magnitude = '1,000-10,000' THEN 4

WHEN order_of_magnitude = '10,000-100,000' THEN 5

WHEN order_of_magnitude = '100,000-1,000,000' THEN 6

WHEN order_of_magnitude = '1,000,000-10,000,000' THEN 7

ELSE 8

END;