NavidCopy of Untitled Query
Updated 2022-11-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
initcap(l.PROJECT_NAME, ' ') as type,
count(distinct ORIGIN_FROM_ADDRESS) as user_count,
count(distinct tx_hash) as transactions_count,
row_number() over (order by transactions_count desc) as rn,
concat(lpad(rn,3,'0'),' - ',type) as type_rn
from
optimism.core.fact_event_logs
JOIN optimism.core.dim_labels l ON ADDRESS=ORIGIN_TO_ADDRESS
where
contract_address='0x4200000000000000000000000000000000000042' and
TX_STATUS = 'SUCCESS'
GROUP BY
1
ORDER BY
type_rn asc
limit 20
Run a query to Download Data