Query editor
WITH stake_dates AS (SELECT"from" AS address,MIN(evt_block_time) AS first_stake_time,MAX(evt_block_time) AS last_stake_timeFROM erc20_base.evt_transferWHEREcontract_address = 0x98d0baa52b2d063e780de12f615f963fe8537553AND "to" = 0x548D3B444da39686d1a6F1544781d154e7cD1EF7GROUP BY1), stake AS (SELECT"from" AS address,SUM(value / 1e18) AS stakedFROM erc20_base.evt_transferWHEREcontract_address = 0x98d0baa52b2d063e780de12f615f963fe8537553AND "to" = 0x548D3B444da39686d1a6F1544781d154e7cD1EF7GROUP BY1), unstake AS (SELECT"to" AS address,SUM(value / 1e18) AS unstakedFROM erc20_base.evt_transferWHEREcontract_address = 0x98d0baa52b2d063e780de12f615f963fe8537553AND "from" = 0x548D3B444da39686d1a6F1544781d154e7cD1EF7GROUP BY1),base AS (-- wrap your original final SELECTSELECTs.address,s.staked - COALESCE(u.unstaked, 0) AS total_staked,ROW_NUMBER() OVER (ORDER BY s.staked - COALESCE(u.unstaked, 0) DESC) AS rank,(s.staked - COALESCE(u.unstaked, 0)) / (SELECTSUM(s2.staked - COALESCE(u2.unstaked, 0))FROM stake AS s2LEFT JOIN unstake AS u2ON s2.address = u2.addressWHEREs2.staked - COALESCE(u2.unstaked, 0) > 0) * 100 AS percentage_of_total,sd.first_stake_time AS stake_start_date,DATE_DIFF('day', sd.first_stake_time, CURRENT_DATE) AS days_stakedFROM stake AS sLEFT JOIN unstake AS uON s.address = u.addressLEFT JOIN stake_dates AS sdON s.address = sd.addressWHEREs.staked - COALESCE(u.unstaked, 0) > 0)