service_id,

name,

count(distinct donor_address) as unique_donors,

count(*) as donation_count,

sum(eth_amount_usd) as total_usd_received,

sum(eth_amount) as total_eth_received,

avg(eth_amount_usd) as avg_donation_usd,

max(eth_amount_usd) as largest_donation_usd,

min(block_timestamp) as first_donation_date,

max(block_timestamp) as last_donation_date

from crosschain.olas.ez_service_donations

where block_timestamp >= dateadd(month, -3, date_trunc('month', current_date))

group by 1, 2

order by total_usd_received desc

limit 20;