Query editor
SELECTaddress AS user,endorsed_delegate,"ethDYDX Balance","wethDYDX Balance","stkDYDX Balance","all_balance",CASE--ethDYDX no / wethDYDX noWHEN "ethDYDX Delegatee?" = 'No'AND "ethDYDX Delegator?" = 'No'AND "wethDYDX Delegatee?" = 'No'AND "wethDYDX Delegator?" = 'No'AND "stkDYDX Delegatee?" = 'No'AND "stkDYDX Delegator?" = 'No' THEN r."all_balance"WHEN "ethDYDX Delegatee?" = 'No'AND "ethDYDX Delegator?" = 'No'AND "wethDYDX Delegatee?" = 'No'AND "wethDYDX Delegator?" = 'No'AND "stkDYDX Delegatee?" = 'Yes'AND "stkDYDX Delegator?" = 'No' THEN r."ethDYDX Balance" + r."wethDYDX Balance" + r."stkDYDX_Proposal_Current_Power"WHEN "ethDYDX Delegatee?" = 'No'AND "ethDYDX Delegator?" = 'No'AND "wethDYDX Delegatee?" = 'No'AND "wethDYDX Delegator?" = 'No'AND "stkDYDX Delegatee?" = 'No'AND "stkDYDX Delegator?" = 'Yes' THEN r."ethDYDX Balance" + r."wethDYDX Balance" + r."stkDYDX_Proposal_Current_Power_Delegator"-- ethDYDX no / wethDYDX delegatee yesWHEN "ethDYDX Delegatee?" = 'No'AND "ethDYDX Delegator?" = 'No'AND "wethDYDX Delegatee?" = 'Yes'AND "wethDYDX Delegator?" = 'No'AND "stkDYDX Delegatee?" = 'No'AND "stkDYDX Delegator?" = 'No' THEN r."ethDYDX Balance" + r."wethDYDX_Proposal_Current_Power" + r."stkDYDX Balance"WHEN "ethDYDX Delegatee?" = 'No'AND "ethDYDX Delegator?" = 'No'AND "wethDYDX Delegatee?" = 'Yes'AND "wethDYDX Delegator?" = 'No'AND "stkDYDX Delegatee?" = 'Yes'AND "stkDYDX Delegator?" = 'No' THEN r."ethDYDX Balance" + r."wethDYDX_Proposal_Current_Power" + r."stkDYDX_Proposal_Current_Power"WHEN "ethDYDX Delegatee?" = 'No'AND "ethDYDX Delegator?" = 'No'AND "wethDYDX Delegatee?" = 'Yes'AND "wethDYDX Delegator?" = 'No'AND "stkDYDX Delegatee?" = 'No'AND "stkDYDX Delegator?" = 'Yes' THEN r."ethDYDX Balance" + r."wethDYDX_Proposal_Current_Power" + r."stkDYDX_Proposal_Current_Power_Delegator"WHEN "ethDYDX Delegatee?" = 'No'AND "ethDYDX Delegator?" = 'No'AND "wethDYDX Delegatee?" = 'Yes'AND "wethDYDX Delegator?" = 'No'AND "stkDYDX Delegatee?" = 'Yes'AND "stkDYDX Delegator?" = 'Yes' THEN r."ethDYDX Balance" + r."wethDYDX_Proposal_Current_Power" + r."stkDYDX_Proposal_Current_Power_Delegator"--ethDYDX no / wethDYDX delegator yes