WITH tb1 AS (

SELECT

outF.dest_chain as chain,

outF.chain_total outflow,

outF.volume_chain_rank outflow_rank,

inF.chain_total inflow,

inF.incoming_chain_volume_rank inflow_rank

FROM $query('70da365c-adcd-4bcd-9a23-aa45e1caea8e') as outF LEFT OUTER JOIN $query('40fd1c3b-31ab-4443-8445-69a4799452a5') as inF ON outF.dest_chain=inF.src_chain

WHERE outflow_rank <= 12

ORDER BY outflow_rank

SELECT

'Inflow' as direction,

sum(inflow) as inflow

FROM tb1

SELECT

'Outflow' as direction,

sum(outflow) as outflow,

FROM tb1