select

block_timestamp,

tx_hash,

status

from optimism.core.fact_transactions

where block_timestamp::date >= '2022-07-01' and block_timestamp::date <= '2022-07-31'

select

block_timestamp::date as "Days",

status as "Status",

count(tx_hash) as "Number of transactions"

from transactions

group by "Days", "Status"