anomoneTesting group by error
Updated 2022-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
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