-- forked from Sponsored Boss event 1 @ https://flipsidecrypto.xyz/studio/queries/297fc630-a536-4d0b-90c1-9cf6c6c7d37f
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-10-11 03:00:00.000' and '2024-10-28 03:00:00.000'
group by DECODED_LOG ['attacker']
ORDER by total_damage DESC;