Query editor
WITH original AS (-- your exact original query, untouchedselectt.arena_user,t.value as arena_claimed,s.value as arena_staked,s.value / t.value * 100 as percentage_stakedfrom(select "to" as arena_user, sum(value/1e18) as valuefrom erc20_avalanche_c.evt_transfer twhere contract_address = FROM_HEX('0xB8d7710f7d8349A506b75dD184F05777c82dAd0C')group by 1) tleft join(select "from" as arena_user, sum(value/1e18) as valuefrom erc20_avalanche_c.evt_transfer twhere contract_address = FROM_HEX('0xB8d7710f7d8349A506b75dD184F05777c82dAd0C')and "to" = 0xEFFb809d99142cE3B51C1796C096f5b01B4AAec4group by 1) son s.arena_user = t.arena_user)SELECTo.*,e.name AS ens_nameFROM original oLEFT JOIN labels.ens eON e.address = o.arena_userORDER BY o.arena_claimed DESC, o.arena_staked DESC;