TX_Count AS(

SELECT TO_ADDRESS,COUNT(TX_HASH) Transaction_Count FROM ethereum.core.fact_transactions

WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 120 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_Count

FROM AddressName LEFT JOIN TX_Count ON TO_ADDRESS = ADDRESS WHERE TRANSACTION_COUNT IS NOT NULL