SELECT sum(TX_FEE) as total_fee,
'Ethereum' as lable
FROM ethereum.core.fact_transactions
WHERE TX_HASH IN (
SELECT TX_HASH FROM ethereum.sushi.ez_borrowing
UNION
SELECT TX_HASH FROM ethereum.sushi.ez_lending
)
UNION
SELECT sum(TX_FEE) as total_fee,
'Polygon' as lable
FROM polygon.core.fact_transactions
WHERE TX_HASH IN (
SELECT TX_HASH FROM polygon.sushi.ez_borrowing
UNION
SELECT TX_HASH FROM polygon.sushi.ez_lending
)