SELECT *

FROM ethereum.core.dim_labels

WHERE label = 'tornado cash'

), tc_txs AS (

SELECT a.*, b.*

FROM ethereum.core.fact_transactions AS a JOIN tc_addresses as b on a.TO_ADDRESS = b.address

WHERE a.status = 'SUCCESS'

SELECT address, address_name, count(DISTINCT tx_hash) as total_tx, sum(eth_value)

FROM tc_txs

WHERE block_timestamp > CURRENT_DATE - 30

GROUP BY address, address_name

ORDER BY total_tx DESC