POOL_ADDRESS,

(sum (STAKE_AMOUNT))/1e24 t_stake

FROM near.core.dim_staking_actions

WHERE ACTION='Stake'

GROUP BY 1

ORDER BY 2 DESC