TX_Value AS(

SELECT TO_ADDRESS,sum(ETH_VALUE) Transaction_Value FROM ethereum.core.fact_transactions

WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 365 AND TO_ADDRESS IN

(SELECT ADDRESS FROM ethereum.core.dim_labels WHERE ADDRESS_NAME LIKE 'tornado.cash%' GROUP BY 1)

GROUP BY 1 ORDER BY 2 DESC),

AddressName AS(SELECT ADDRESS,ADDRESS_Name FROM ethereum.core.dim_labels WHERE ADDRESS_NAME LIKE 'tornado.cash%' GROUP BY 1,2)

SELECT ADDRESS_Name,Transaction_Value

FROM AddressName LEFT JOIN TX_Value ON TO_ADDRESS = ADDRESS WHERE Transaction_Value > 0