eferTop10 Solana Program
Updated 2022-07-07
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
›
⌄
⌄
WITH labels AS (
SELECT ADDRESS, LABEL
FROM solana.core.dim_labels
), top10 AS(
SELECT
PROGRAM_ID AS program,
COUNT(TX_ID) AS total_interactions
FROM solana.core.fact_events
WHERE CAST(BLOCK_TIMESTAMP AS DATE) >= '2022-01-01'
GROUP BY program
ORDER BY total_interactions DESC
LIMIT 10
)
SELECT * FROM top10
ORDER BY total_interactions DESC
/*
SELECT
program,
COALESCE(labels.label, NULL)
total_interactions
FROM top5
LEF JOIN (
SELECT * FROM labels
) labels
ON program=labels.address
ORDER BY total_interactions
*/
Run a query to Download Data