Query editor
1with2 txns as (3 select4 *5 from6 ethereum.transactions e7 join ambirewallet_ethereum.IdentityFactory_evt_LogDeployed i on i.addr = e.to8 )9select10 count(1) as Transactions11from12 txns
with
txns as (
select
*
from
ethereum.transactions e
join ambirewallet_ethereum.IdentityFactory_evt_LogDeployed i on i.addr = e.to
)
count(1) as Transactions
txns