when amount_loaned/pow(10,decimals) < 1 then 'amount_loaned < 1'

when amount_loaned/pow(10,decimals) >= 1 and amount_loaned/pow(10,decimals) < 1e6 then 'amount_loaned >= 1 and < 1M'

when amount_loaned/pow(10,decimals) >= 1e6 and amount_loaned/pow(10,decimals) < 1e7 then 'amount_loaned >= 1M and < 10M'

when amount_loaned/pow(10,decimals) >= 1e7 and amount_loaned/pow(10,decimals) < 1e8 then 'amount_loaned >= 10M and < 100M'

when amount_loaned/pow(10,decimals) >= 1e8 then 'amount_loaned >= 100M'

end as histogram

from ethereum.maker.ez_flash_loans

where tx_status='SUCCESS'

group by 2