initcap(l.LABEL_TYPE) 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,

row_number() over (order by user_count desc) as rnu,

concat(lpad(rn,3,'0'),' - ',type) as type_rn,

concat(lpad(rnu,3,'0'),' - ',type) as type_rnu

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

1