flipsidecryptoPayments by Chain
    Updated 2023-07-10
    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