select

date_trunc('month',BLOCK_TIMESTAMP) as month,

count(distinct case when EVENT_NAME = 'Request' then REQUEST_ID end) as requests,

count(distinct case when EVENT_NAME = 'Deliver' then REQUEST_ID end) as delivers,

delivers/requests * 100 as share

from crosschain.olas.fact_mech_activity

group by 1

order by 1 desc