Kruys-Collinsawkward-lime
Updated 2024-09-16
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
COUNT(DISTINCT delegator_address) AS unique_delegators,
COUNT(*) AS total_staking_transactions,
SUM(CASE WHEN action = 'delegate' AND tx_succeeded = TRUE THEN 1 ELSE 0 END) AS total_delegate_transactions
FROM
axelar.gov.fact_staking
WHERE
action IN ('delegate', 'undelegate', 'redelegate')
AND tx_succeeded = TRUE;
QueryRunArchived: QueryRun has been archived