WITH d AS (
SELECT
vault AS v1,
SUM(amount_deposited) AS deposits
FROM
ethereum.maker.ez_deposits
GROUP BY
v1),
w AS (
SELECT
vault AS v2,
SUM(COLLATERAL_BALANCE) AS liquidations
FROM
ethereum.maker.ez_liquidations
GROUP BY
v2)
SELECT
d.v1,
d.deposits,
w.v2,
w.liquidations
FROM
d
JOIN
w ON d.v1 = w.v2