par_rnM3
Updated 2024-12-29
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
›
⌄
WITH staking AS (
SELECT
SIGNER_ID,
SUM(
CASE
WHEN ACTION = 'staking' THEN AMOUNT
ELSE 0
END
) AS amount,
FROM
near.gov.fact_staking_actions
WHERE
ADDRESS LIKE 'meteor%'
GROUP BY
1
)
SELECT
SIGNER_ID AS "Staker",
amount AS "Near Staked"
FROM
staking
WHERE
amount > 0
ORDER BY
amount DESC
LIMIT
100
QueryRunArchived: QueryRun has been archived