(SELECT

MAX(EPOCH) AS MAX_EPOCH

FROM

solana.gov.fact_stake_accounts)

SELECT

COUNT(DISTINCT FACT_STAKE_ACCOUNTS_ID) AS ACCOUNTS ,

VOTE_PUBKEY

FROM

solana.gov.fact_stake_accounts

WHERE

EPOCH IN (SELECT MAX_EPOCH FROM T1)

AND

ACTIVE_STAKE > 0

AND

EPOCH != DEACTIVATION_EPOCH

AND

ACTIVATION_EPOCH IS NOT NULL

GROUP BY 2