WITH net_staking AS (

SELECT

SIGNER_ID,

SUM(CASE WHEN ACTION = 'staking' THEN AMOUNT ELSE 0 END) AS total_staked,

SUM(CASE WHEN ACTION = 'unstaking' THEN AMOUNT ELSE 0 END) AS total_unstaked,

SUM(CASE WHEN ACTION = 'staking' THEN AMOUNT ELSE 0 END) -

SUM(CASE WHEN ACTION = 'unstaking' THEN AMOUNT ELSE 0 END) AS net_amount

FROM

near.gov.fact_staking_actions

WHERE

ADDRESS = 'here.poolv1.near'

GROUP BY

SIGNER_ID

(SELECT COUNT(DISTINCT SIGNER_ID) FROM near.gov.fact_staking_actions WHERE ADDRESS LIKE 'here%') AS total_users,

(SELECT COUNT(*) FROM near.gov.fact_staking_actions WHERE ADDRESS LIKE 'here%') AS total_transactions,

(SELECT SUM(AMOUNT) FROM near.gov.fact_staking_actions WHERE ADDRESS LIKE 'here%' AND ACTION = 'staking') AS total_staked_amount,

(SELECT SUM(AMOUNT) FROM near.gov.fact_staking_actions WHERE ADDRESS LIKE 'here%' AND ACTION = 'unstaking') AS total_unstaked_amount,

SUM(net_amount) AS current_tvl,

COUNT(SIGNER_ID) AS current_stakers

net_staking