epoch,

MAX(inserted_timestamp) AS inserted_timestamp,

COUNT(DISTINCT node_pubkey) AS validators,

SUM(active_stake / POW(10,9)) AS total_staked

FROM

solana.gov.fact_validators

WHERE

active_stake > 0

AND delinquent = FALSE

GROUP BY

epoch

ORDER BY

epoch desc