Query editor
WITHcorrect_delegate AS (SELECT*FROMdydx_perpetual_ethereum.DydxToken_evt_DelegateChangedWHEREdelegatee <> delegatorUNIONSELECT*FROMdydx_ethereum.WrappedEthereumDydxToken_evt_DelegateChangedWHEREdelegatee <> delegator),ethDYDXdelegatee AS (WITHdelegate AS (SELECT DISTINCT"delegationType","delegatee",COUNT(DISTINCT delegator) AS "# Delegators"FROMcorrect_delegateGROUP BYdelegatee,"delegationType"),current_power_table AS (SELECT"user",power."delegationType",CAST(amount AS DOUBLE) / 1e18 AS current_power,"# Delegators",RANK() OVER (PARTITION BYpower."user",d."delegationType"ORDER BYpower."evt_block_time" DESC NULLS FIRST) AS power_traceFROMdydx_perpetual_ethereum.DydxToken_evt_DelegatedPowerChanged AS powerJOIN delegate AS d ON power."user" = d."delegatee"AND d."delegationType" = power."delegationType")SELECT"user" AS delegate,MAX(CASEWHEN "delegationType" = 0 THEN "# Delegators"END) AS ethDYDX_Proposal_Delegators,MAX(CASEWHEN "delegationType" = 1 THEN "# Delegators"END) AS ethDYDX_Voting_Delegators,MAX(