event_name as "Action Taken",

sum(FLASHLOAN_AMOUNT_USD) as "Flashloan Volume USD"

from ethereum.aave.ez_flashloans left outer join ethereum.core.fact_event_logs

on ethereum.aave.ez_flashloans.tx_hash = ethereum.core.fact_event_logs.tx_hash

where FLASHLOAN_AMOUNT_USD < 1e9

and (event_name like '%Liquidity%'

or event_name like '%Liquidation%' or

event_name like '%Liquidate%' )

group by 1

order by 2 desc