With summary as (
SELECT SUM(stake_amount)/pow(10, 24) as summ FROM near.core.dim_staking_actions WHERE action = 'Stake'
)
SELECT '1B NEAR Token' as "NEAR total Supply",
'835,336,099 NEAR Token' as "NEAR Circulating Supply",
(summ/835336099) * 100 as "% of NEAR Staked" from summary
-- NEAR has a circulating supply of 835,336,099