KeyrockSEI - Percentage Stakers
Updated 2024-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH
CTE_1 AS (
SELECT COUNT(DISTINCT TX_CALLER_ADDRESS) AS Stakers
FROM sei.gov.fact_staking
),
CTE_2 AS (
SELECT COUNT(DISTINCT tx_from) AS tot_wallet
FROM sei.core.fact_transactions
WHERE tx_succeeded = 'TRUE'
)
SELECT
CTE_1.Stakers,
CTE_2.tot_wallet,
CTE_1.Stakers * 100.0 / NULLIF(CTE_2.tot_wallet, 0) AS percentage_stakers
FROM
CTE_1, CTE_2;
QueryRunArchived: QueryRun has been archived