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