select

donor_address,

date_trunc('month', block_timestamp) as donation_month,

count(*) as donations_in_month,

sum(eth_amount_usd) as total_donation_value

from crosschain.olas.ez_service_donations

where block_timestamp >= dateadd(year, -1, current_date)

group by donor_address, donation_month

),

support_level_classification as (

select

donor_address,

donation_month,

donations_in_month,

total_donation_value,

case

when donations_in_month >= 5 then 'High Support'

when donations_in_month between 2 and 4 then 'Moderate Support'

else 'Low Support'

end as support_level

from monthly_donations

),

support_level_summary as (

select

donation_month,

support_level,

count(donor_address) as donor_count,

avg(donations_in_month) as avg_donations,

avg(total_donation_value) as avg_donation_value

from support_level_classification

group by donation_month, support_level