sssstatisticSponsored Boss event 2 (11th Oct 3 AM UTC - 28th Oct 3 AM UTC)
    Updated 2024-11-18
    -- 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;


    QueryRunArchived: QueryRun has been archived