node_id,

count(distinct delegator) as Users_Count,

row_number() over (order by Users_Count DESC) as rank,

rank || '. ' || left(node_id, 4) || '...' || right(node_id, 4) as validator,

count(distinct tx_id) as TX_Count,

sum(amount) as Total_Volume

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE'

group by 1