select

from crosschain.olas.ez_service_staking

where PROGRAM_NAME in ('Everest','Alpine','Coastal')

) ,

staker_everest as (

select

BLOCK_TIMESTAMP,

tx_hash,

MULTISIG_ADDRESS as multisig,

OWNER_ADDRESS as owner,

SERVICE_ID as serviceId,

row_number() OVER (

partition BY serviceId

order by

BLOCK_TIMESTAMP desc

) as r_no

from expedition

-- PROGRAM_NAME in ('Everest', 'Coastal', 'Alpine')

),

staker_everest_last as (

select

BLOCK_TIMESTAMP,

multisig,

owner,

serviceId,

from

staker_everest

where

r_no = 1

),