(SUM(CASE WHEN receipt_succeeded = TRUE THEN 1 ELSE 0 END) * 100.0 / COUNT(*)) AS staking_success_rate,

(SELECT (SUM(CASE WHEN receipt_succeeded = TRUE THEN 1 ELSE 0 END) * 100.0 / COUNT(*))

FROM

near.core.fact_actions_events_function_call

WHERE

receiver_id = 'meta-pool.near'

AND method_name IN ('unstake', 'unstake_all','liquid_unstake' )) as unstaking_success_rate

FROM

near.core.fact_actions_events_function_call

WHERE

receiver_id = 'meta-pool.near'

AND method_name = 'deposit_and_stake'