SELECT SUM(FLASHLOAN_AMOUNT_USD) as Total_Flashloan_USD

FROM ethereum.aave.ez_flashloans

WHERE FLASHLOAN_AMOUNT_USD is not null

),

address_flashloans AS (

SELECT

INITIATOR_ADDRESS,

SUM(FLASHLOAN_AMOUNT_USD) as Address_Flashloan_USD

FROM ethereum.aave.ez_flashloans

WHERE FLASHLOAN_AMOUNT_USD is not null

GROUP BY 1

SELECT

af.INITIATOR_ADDRESS,

af.Address_Flashloan_USD,

(af.Address_Flashloan_USD / tf.Total_Flashloan_USD) * 100 as Percentage_of_Total

FROM address_flashloans af

CROSS JOIN total_flashloans tf

ORDER BY Percentage_of_Total DESC

LIMIT 20