flipsidecryptoClaims by Protocol
    Updated 2023-07-28
    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%'
    group by protocol
    having claims > 0
    Run a query to Download Data