select event_name, count(distinct(tx_hash)) as tx_num from optimism.core.fact_event_logs
where tx_status = 'SUCCESS'
and event_name != ''
and block_timestamp::date between '2022-07-27' and '2022-08-05'
group by event_name
order by tx_num desc
limit 10