status,

count(distinct(tx_hash)) as n_tx

from optimism.core.fact_transactions

group by status