WITH donation_metrics AS (

SELECT

DATE_TRUNC('month', block_timestamp) as month,

COUNT(DISTINCT service_id) as services_receiving_donations,

COUNT(DISTINCT donor_address) as unique_donors,

SUM(eth_amount) as total_eth_donated,

SUM(eth_amount_usd) as total_usd_donated,

AVG(eth_amount) as avg_donation_size_eth

FROM crosschain.olas.ez_service_donations

GROUP BY 1

ORDER BY 1

SELECT

month,

services_receiving_donations,

unique_donors,

total_eth_donated,

total_usd_donated,

avg_donation_size_eth,

total_eth_donated / NULLIF(services_receiving_donations, 0) as avg_eth_per_service

FROM donation_metrics;