where PROGRAM_ID='hadeK9DLv9eA7ya5KCTqSvSvRZeJC3JgD5a9Y3CNbvu'),

tb2 AS (SELECT 'sold' AS action,A.TX_ID,SIGNERS[0] AS trader,TX_FROM,TX_TO,AMOUNT,MINT FROM solana.core.fact_transfers A inner join solana.core.fact_transactions B on A.TX_ID=B.TX_ID

WHERE A.TX_ID in (select TX from tb )

and TX_to=SIGNERS[0] and mint='So11111111111111111111111111111111111111112'

union ALL

SELECT 'buy' AS action,A.TX_ID,SIGNERS[0] AS trader,TX_FROM,TX_TO,AMOUNT,MINT FROM solana.core.fact_transfers A inner join solana.core.fact_transactions B on A.TX_ID=B.TX_ID

WHERE A.TX_ID in (select TX from tb )

and TX_from=SIGNERS[0] and mint='So11111111111111111111111111111111111111112' and TX_TO!='My11111111111111111111111111111111111111111')

select sum(AMOUNT) from tb2