SELECT sum(amount) AS outflow_amount

FROM solana.core.fact_transfers t

,solana.core.dim_labels l

WHERE t.TX_TO = l.address

AND mint ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')

, inflow AS (

SELECT sum(amount) AS inflow_amount

FROM solana.core.fact_transfers t

,solana.core.dim_labels l

WHERE t.TX_FROM = l.address

and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')

SELECT

inflow_amount,

outflow_amount,

inflow_amount - outflow_amount AS "market cap"

FROM inflow,outflow