---ref: https://cityofnear.xyz/
SELECT
tx_receiver as governor,
COUNT(DISTINCT tx_signer) as number_of_unstakers,
COUNT(DISTINCT a.TX_HASH) as number_transactions,
try_parse_json(replace(args, '\\')):amount as amount, -- raw amount
SUM(div0(ZEROIFNULL(amount),pow(10,24))) as near_unstaked,
iff(args::string LIKE '%,%',1,0) as check_sys
FROM near.core.fact_actions_events_function_call a
JOIN near.core.fact_transactions b
ON a.tx_hash = b.tx_hash
WHERE tx_receiver ilike '%.pool%'
AND method_name in ('unstake_all', 'unstake')
AND check_sys = 0
GROUP BY governor, args
ORDER BY near_unstaked DESC -- Top 50 proposals by amounts unstaked
LIMIT 50