-- 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