WITH LOCKER_TX AS (
SELECT
block_timestamp::date as fecha,
tx_id
FROM
solana.events
WHERE
instruction:programId ='LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
AND fecha >= '2022-02-01'
AND succeeded = 'TRUE'
),
SBR_LOCKER as (
SELECT
tx_id,
tx_from_address,
pre_mint,
post_mint
FROM solana.transactions
WHERE tx_id in (SELECT tx_id FROM LOCKER_TX)
AND pre_mint = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
)
SELECT
tx_from_address, count(tx_id)
FROM SBR_LOCKER
GROUP BY 1
ORDER BY 2 desc, 1
LIMIT 20