sinahosseinzadehUntitled Query
    Updated 2022-08-10
    with tornado as(
    select
    address,
    address_name
    from ethereum.core.dim_labels
    where address_name like '%tornado%')

    select
    distinct to_address,
    address_name ,
    count(tx_hash) as transaction_count
    from ethereum.core.fact_transactions a
    inner join tornado b on a.TO_ADDRESS=b.ADDRESS
    where TO_ADDRESS in (select address from tornado)
    group by 1,2
    order by 3 desc
    limit 20;
    Run a query to Download Data