flipsidecryptoPayments by Chain
Updated 2023-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select upper(coalesce(n.name, b.project_name)) as blockchain,
count(distinct s.created_by_id) as user_count
from BI_ANALYTICS.SILVER.BOUNTIES b
left join BI_ANALYTICS.SILVER.NETWORKS n
on b.id = n.bounty_id
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
and payment_id is not null
group by 1
having user_count > 0
order by user_count desc
Run a query to Download Data