sinahosseinzadehUntitled Query
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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