-- forked from MLDZMN / Mech request by traders copy copy @ https://flipsidecrypto.xyz/MLDZMN/q/vKBGH8k2HitS/mech-request-by-traders-copy-copy
-- forked from Mech request by traders copy @ https://flipsidecrypto.xyz/studio/queries/e5890124-d07e-478e-a21d-aa0f5e1a7690
select
date_trunc('day',BLOCK_TIMESTAMP) as day,
count(*) as "Requests",
count(distinct SENDER_ADDRESS) as "Senders",
"Requests"/"Senders" as "Avg Requests per Sender"
from crosschain.olas.fact_mech_activity
where BLOCK_TIMESTAMP>= current_date - 90
group by 1
order by 1 desc