par_rnCopy of Gaming on Sol 3 - 5
Updated 2023-02-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
--credit SQL https://app.flipsidecrypto.com/velocity/queries/bf729385-123f-4e00-a0d4-84da293884d1
WITH tab1 as (
SELECT
CASE WHEN program_id='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5' then signers[0] END as users
FROM solana.core.fact_events
where program_id in ('StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v', 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc', 'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5')
), tab2 as (
SELECT
CASE WHEN program_id='ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc' then signers[0] END AS users
FROM solana.core.fact_events
where program_id in ('StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v', 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc', 'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5')
), tab3 as (
SELECT
CASE WHEN program_id='StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v' then signers[0] END AS users
FROM solana.core.fact_events
where program_id in ('StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v', 'ATLocKpzDbTokxgvnLew3d7drZkEzLzDpzwgrgWKDbmc', 'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5')
)
SELECT
address_name,
COUNT(DISTINCT signers[0]) as transactions
FROM solana.core.fact_events
LEFT outer JOIN solana.core.dim_labels
ON program_id = ADDRESS
WHERE signers[0] in (SELECT * FROM tab1)
GROUP BY 1
HAVING NOT address_name is NULL
ORDER BY 2 DESC
LIMIT 10
Run a query to Download Data