AS (SELECT address,

address_name,

label_type,

label_subtype,

blockchain

FROM flipside_prod_db.crosschain.address_labels

WHERE project_name LIKE 'tornado cash')

SELECT to_address AS address,

address_name,

Sum(eth_value) AS eth_value,

Count(DISTINCT txn.tx_hash) AS no_of_txns

FROM ethereum.core.fact_transactions txn

INNER JOIN tornado_addresses addr

ON txn.to_address = addr.address

WHERE to_address IN (SELECT address

FROM tornado_addresses)

AND block_timestamp >= Dateadd(month, -12, Getdate())

GROUP BY to_address,

address_name

ORDER BY eth_value DESC