with optimisim_data as (select * from optimism.core.dim_labels inner join optimism.core.fact_event_logs
on contract_address = address
where label_type = 'dex' or label_type = 'dapp' )
select count(distinct tx_hash) as tx,project_name as pn from optimisim_data
where label_type = 'dex'
group by pn