select

ETH_FROM_ADDRESS,

sum(amount) as Contribution_Amount

FROM optimism.core.ez_eth_transfers

where ETH_TO_ADDRESS in('0xc67ce28d0343e5972f3b1711c32e206ab5a238d6', '0x824026ca57bca5c7c0b98f62e5d0173cd1630dad')

and ORIGIN_FUNCTION_SIGNATURE in ('0xa2e4f607', '0x2b2d4b68')

group by 1)

select count(ETH_FROM_ADDRESS) as Contributors_count,

CASE

when Contribution_Amount >= 100 then '100 ETH'

when Contribution_Amount < 100 and Contribution_Amount >= 50 then '50 to 99 ETH'

when Contribution_Amount < 50 and Contribution_Amount >= 10 then '10 to 50 ETH'

when Contribution_Amount < 10 and Contribution_Amount > 1 then '1 to 10 ETH'

when Contribution_Amount = 1 then '1 ETH'

when Contribution_Amount >= 0.5 and Contribution_Amount < 1 then '0.5 to 1 ETH'

when Contribution_Amount < 0.5 and Contribution_Amount >= 0.1 then '0.1 to 0.5 ETH'

else 'Below 0.1 ETH'

end as Contribution_Distribution

from source

group by 2