SELECT

delegator_address,

SUM(CASE WHEN action = 'delegate' THEN amount / 1000000 ELSE 0 END) -

SUM(CASE WHEN action = 'undelegate' THEN amount / 1000000 ELSE 0 END) AS active_staked

FROM sei.gov.fact_staking

GROUP BY delegator_address

HAVING active_staked > 1

SELECT

COUNT(DISTINCT validator_address) AS "Active Validators",

(SELECT COUNT(DISTINCT delegator_address) FROM active_delegators) AS "Active Delegators"

FROM (

SELECT

validator_address,

SUM(CASE WHEN action = 'delegate' THEN amount / 1000000 ELSE 0 END) -

SUM(CASE WHEN action = 'undelegate' THEN amount / 1000000 ELSE 0 END) AS active_staked

FROM sei.gov.fact_staking

GROUP BY validator_address

) AS validator_balances

WHERE active_staked > 20000000;