signers[0] as WALLET

----------------------------------------------------

,zeroifnull(sum(case when value:parsed:info:mint = 'BptqSqun32aKfZz9igU1Mkurm3MFRgvPho5uwwH7rbky'

AND value:parsed:type = 'transfer'

then value:parsed:info:amount

end)) as "ATLAS_collected"

from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)

WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'

AND succeeded = 'true'

AND block_timestamp > '2024-04-02' AND block_timestamp < '2024-07-01'

group by 1