WITH addresses AS (
SELECT
DISTINCT INNER_INSTRUCTION:instructions[0]:parsed:info:source::string AS unique_addresses
FROM solana.events
WHERE INSTRUCTION:parsed:info:mint::string='3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt'
AND INDEX=0
AND block_timestamp >= '2022-01-28'
AND SUCCEEDED =TRUE
)
SELECT
CASE
WHEN POST_MINT ='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' THEN 'BTC'
WHEN POST_MINT ='4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2' THEN 'fcSOL'
WHEN POST_MINT ='3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt' THEN 'fcBTC'
WHEN POST_MINT ='6UA3yn28XecAHLTwoCtjfzy3WcyQj1x13bxnH8urUiKt' THEN 'fcmSOL'
WHEN POST_MINT ='GjnoPUjQiEUYWuKAbMax2cM1Eony8Yutc133wuSun9hS' THEN 'fcETH'
WHEN POST_MINT ='7wDh4VCTPwx41kvbLE6fkFgMEjnqw7NpGJvQtNabCm2B' THEN 'fcFTT'
WHEN POST_MINT ='5SLqZSywodLS8ih6U2AAioZrxpgR149hR8SApmCB7r5X' THEN 'fcSRM'
WHEN POST_MINT ='4sTuzTYfcE2NF7zy6Sy8XhVcNLa6JQSLrx3roy97n4sD' THEN 'fcMNGO'
WHEN POST_MINT ='95sn4kgeJnnBfRCD8S2quu4HS9Y6vb7JDuXrarnmEjYE' THEN 'fcLUNA'
WHEN POST_MINT ='SoAnGsHVqSyaN4MjWoPCcftC1V6oSeNxLJjF5TXrtuL' THEN 'fcRAY'
WHEN POST_MINT ='KgV1GvrHQmRBY8sHQQeUKwTm2r2h8t4C8qt12Cw1HVE' THEN 'AVAX (Wormhole)'
WHEN POST_MINT ='5VmdHqvRMbXivuC34w4Hux9zb1y9moiBEQmXDrTR1kV' THEN 'fcscnSOL'
WHEN POST_MINT ='DPMCwE9z9jXaDVDti5aKhdgCWGgsvioz6ZvB9eZjH7UE' THEN 'fcSBR'
ELSE NULL
END AS Volts,
COUNT(TR.TX_FROM_ADDRESS) AS Users_transactions
FROM solana.transactions TR INNER JOIN addresses A ON TR.TX_FROM_ADDRESS = A.unique_addresses
WHERE POST_MINT IS NOT NULL
GROUP BY 1
HAVING Users_transactions < 600
ORDER BY 2 DESC