flipsidecryptoAvalanche Campaign Claims
    Updated 2023-06-06
    -- forked from Claims by Protocol @ https://flipsidecrypto.xyz/edit/queries/5c17adcd-01c4-4464-87e7-84e5d64281f7

    select
    split_part(slug, '-', 2) AS protocol,
    count(s.id) AS claims
    from bi_analytics.silver.bounties b
    left join bi_analytics.silver. claims c
    ON b.id = c.bounty_id
    left join bi_analytics.silver.submissions s
    on c.id = s.claim_id
    where slug like '%axelscore%'
    and protocol = 'btcb'
    group by protocol
    having claims > 0


    Run a query to Download Data