datavortexweekly-yellow
Updated 2024-12-04
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
›
⌄
⌄
/*
SELECT
SUM(CAST(REPLACE(ATTRIBUTE_VALUE, 'usei', '') AS DECIMAL)) / 1000000 AS total_in_millions
FROM sei.core.fact_msg_attributes
WHERE msg_type = 'delegate'
AND ATTRIBUTE_KEY = 'amount';
*/
WITH delegate_data AS (
SELECT
tx_id,
CASE
WHEN ATTRIBUTE_KEY = 'validator' AND msg_type = 'delegate' THEN ATTRIBUTE_VALUE
END AS validator,
CASE
WHEN ATTRIBUTE_KEY = 'amount' AND msg_type = 'delegate' THEN
CAST(REPLACE(ATTRIBUTE_VALUE, 'usei', '') AS DECIMAL) / 1000000
END AS stake_amount
FROM sei.core.fact_msg_attributes
WHERE msg_type = 'delegate'
AND (ATTRIBUTE_KEY = 'validator' OR ATTRIBUTE_KEY = 'amount')
)
SELECT
validator,
SUM(COALESCE(stake_amount, 0)) AS total_staked_in_millions
FROM delegate_data
GROUP BY validator
HAVING SUM(COALESCE(stake_amount, 0)) > 0;
QueryRunArchived: QueryRun has been archived