-- forked from sssstatistic / Sponsored Boss event 3 (11th Nov 3 AM UTC - 18th Nov 3 AM UTC) @ https://flipsidecrypto.xyz/sssstatistic/q/l1G2tHNIHj6t/sponsored-boss-event-3-11th-nov-3-am-utc---18th-nov-3-am-utc
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;