anomoneTesting group by error
    Updated 2022-03-11


    SELECT
    Wallet,
    TX_ID,
    (INNER_INSTRUCTION:instructions[0]:parsed:info:amount )/1e6 as Locked_Amount
    FROM solana.events e
    INNER JOIN (
    SELECT
    INNER_INSTRUCTION:instructions[0]:parsed:info:authority as Wallet,
    sum((INNER_INSTRUCTION:instructions[0]:parsed:info:amount )/1e6) as Locked_Amount FROM solana.events
    WHERE ---TX_ID = '5m3cXquqMncfCgEArC5AHnoZMYUckPzJcJ3FFDhiEuDjBNRB9odCmVDygBk22C7AivGMF4yM157NaPbpR3ekkebH'
    PRETOKENBALANCES[0]:mint = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
    AND Instruction:programId = 'LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
    AND INNER_INSTRUCTION:instructions[0]:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
    AND SUCCEEDED = 'True'
    AND date_trunc('month', BLOCK_TIMESTAMP) like '2022-02-01 %' --Filtering for the month of Feb
    GROUP BY Wallet
    ORDER BY Locked_Amount DESC
    LIMIT 20) t
    ON e.INNER_INSTRUCTION:instructions[0]:parsed:info:authority = t.Wallet
    WHERE PRETOKENBALANCES[0]:mint = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
    AND Instruction:programId = 'LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
    AND INNER_INSTRUCTION:instructions[0]:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
    AND SUCCEEDED = 'True'
    AND date_trunc('month', BLOCK_TIMESTAMP) like '2022-02-01 %'

    Run a query to Download Data