select
epoch,
split_part(data_center_key, '-', 2) as country,
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 1,2 order by 1 DESC, 3 desc