select
DECODED_LOG ['attacker'] AS address,
SUM(DECODED_LOG ['damage']) AS total_damage
from
blast.core.ez_decoded_event_logs
where
contract_address = '0xc48f6213a1a4d3ead79db812c2b91817980532c3'
and event_name in ('AttackSponsorBoss')
and block_timestamp BETWEEN '2024-11-11 03:00:00.000' and '2024-11-18 03:00:00.000'
group by DECODED_LOG ['attacker']
ORDER by total_damage DESC;