SELECT instructions[0]:accounts[6] AS acct_6 , instructions[0]:data AS data ,
COUNT(1) AS n , SUM(ARRAY_SIZE(inner_instructions)) AS total_votes
FROM solana.fact_transactions
WHERE block_timestamp <= '2022-03-05'
AND block_timestamp >= '2022-02-15'
AND succeeded = 'True'
AND instructions[0]:programId = 'Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci'
GROUP BY 1, 2