select * from ethereum.core.fact_event_logs

where tx_hash = '0xc93680568d02551951dad6b47f7c1c97ed7b5e275b94077e8a2446310de1c064'

with funding as (

select contract_address, sum(event_inputs:amountRaised)/pow(10,18) as amount_raised

from ethereum.core.fact_event_logs

where event_name = 'FundingClosed'

group by contract_address)

select count(distinct origin_from_address) from ethereum.core.fact_event_logs

where origin_to_address in (select contract_address from funding)