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)