label_type,

count(DISTINCT tx_hash) as total_transaction

from optimism.core.fact_event_logs

inner join optimism.core.dim_labels

on contract_address = address

where date(block_timestamp) >= '2022-07-01'

GROUP by 1