SELECT DISTINCT staker_address

FROM crosschain.olas.ez_olas_staking

),

active_stakers AS (

SELECT DISTINCT staker_address

FROM crosschain.olas.ez_olas_staking

SELECT

(COUNT(DISTINCT active_stakers.staker_address) * 100.0 / COUNT(DISTINCT initial_stakers.staker_address)) AS retention_rate

FROM initial_stakers

LEFT JOIN active_stakers

ON initial_stakers.staker_address = active_stakers.staker_address;