ADDRESS_NAME || ' (' || ADDRESS || ')' AS "Top addresses in the last year",

LABEL_SUBTYPE,

COUNT (DISTINCT TX_HASH) AS " transactions"

FROM flipside_prod_db.crosschain.address_labels l

JOIN ethereum.core.fact_transactions e

ON e.TO_ADDRESS = l.ADDRESS

WHERE PROJECT_NAME = 'tornado cash'

AND BLOCK_TIMESTAMP BETWEEN '2021-01-01' and '2021-12-31'

AND STATUS = 'SUCCESS'

GROUP BY 1,2

ORDER BY 3 DESC

LIMIT 100