Query editor
WITH StakeActions AS (SELECT_user AS wallet,TRY_CAST(SUM(_amount) AS REAL) / 1e18 AS total_stakeFROM layer3_ethereum.Staking_evt_StakedWHEREcontract_address = FROM_HEX('8E02d37b6Cad86039BDd11095b8c879B907F7D10')GROUP BY_user), WithdrawActions AS (SELECT_user AS wallet,TRY_CAST(SUM(_amount) AS REAL) / 1e18 AS total_withdrawFROM layer3_ethereum.Staking_evt_WithdrawnWHEREcontract_address = FROM_HEX('8E02d37b6Cad86039BDd11095b8c879B907F7D10')GROUP BY_user), RewardActions AS (SELECT_user AS wallet,TRY_CAST(SUM(_amount) AS REAL) / 1e18 AS total_rewardsFROM layer3_ethereum.Staking_evt_ClaimRewardAndStakeWHEREcontract_address = FROM_HEX('8E02d37b6Cad86039BDd11095b8c879B907F7D10')GROUP BY_user),StakeDates AS (SELECT_user AS wallet,MIN(evt_block_time) AS first_stake_dateFROM layer3_ethereum.Staking_evt_StakedWHEREcontract_address = FROM_HEX('8E02d37b6Cad86039BDd11095b8c879B907F7D10')GROUP BY_user)SELECTROW_NUMBER() OVER (ORDER BY (ROUND(GREATEST(COALESCE(SA.total_stake, 0) + COALESCE(RA.total_rewards, 0) - COALESCE(WA.total_withdraw, 0),0),2)) DESC) AS rank,SA.wallet,e.name AS ens_name,SD.first_stake_date,ROUND(GREATEST(COALESCE(SA.total_stake, 0) + COALESCE(RA.total_rewards, 0) - COALESCE(WA.total_withdraw, 0),0),2) AS amount_staked