DECODED_LOG:capitalProvider AS capital_provider,

SUM(CAST(DECODED_LOG:amount AS NUMERIC)) AS total_deposits

FROM ethereum.core.ez_decoded_event_logs

WHERE CONTRACT_ADDRESS = LOWER('0xB01b315e32D1D9B5CE93e296D483e1f0aAD39E75')

AND EVENT_NAME = 'DepositMade'

GROUP BY capital_provider

ORDER BY total_deposits DESC;