select

sum(case when value:parsed:info:mint = 'DTbNmLWfu1pm4AuXRKYTApnDNfxMz73VET7nW5wizG5t' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP1_in,

sum(case when value:parsed:info:mint = 'ARNZXUQoBKx3JCX3UJB4aitSnvcjMMphN9YVDFy1PdKq' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP2_in,

sum(case when value:parsed:info:mint = 'GmVKV9W3qZcERxk7hjqwRDcn9Kgtz3XDi7KfFLdGqyaW' then value:parsed:info:tokenAmount:uiAmount ELSE 0 end) AS IMP3_in

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

WHERE program_id = 'FLEET1qqzpexyaDpqb2DGsSzE2sDCizewCg9WjrA6DBW'

AND succeeded = 'true'

AND value:parsed:info:authority = signers[0]::string

AND block_timestamp > '2021-12-16' AND block_timestamp < '2023-06-01'